1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
jasenka [17]
3 years ago
14

The data on a loan has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required an

alysis to answer the questions below.
a. Complete an amortization schedule for a $29,000 loan to be repaid in equal installments at the end of each of the next three years. The interest rate is 9% compounded annually. Round all answers to the nearest cent.
Beginning Repayment Ending
Year Balance Payment Interest of Principal Balance
1 $ $ $ $ $
2 $ $ $ $ $
3 $ $ $ $ $
b. What percentage of the payment represents interest and what percentage represents principal for each of the three years? Round all answers to two decimal places.

% Interest % Principal
Year 1: % %
Year 2: % %
Year 3: % %
c. Why do these percentages change over time?
a. These percentages change over time because even though the total payment is constant the amount of interest paid each year is declining as the remaining or outstanding balance declines.
b. These percentages change over time because even though the total payment is constant the amount of interest paid each year is increasing as the remaining or outstanding balance declines.
c. These percentages change over time because even though the total payment is constant the amount of interest paid each year is declining as the remaining or outstanding balance increases.
d. These percentages change over time because even though the total payment is constant the amount of interest paid each year is increasing as the remaining or outstanding balance increases.
e. These percentages do not change over time; interest and principal are each a constant percentage of the total payment.
Business
1 answer:
algol133 years ago
4 0
A=2610 you didn’t show the question but I help for nomber one
You might be interested in
Explain how each of these terms is reflected in some way during the period of the American Revolution.
Zielflug [23.3K]

Answer:

The American Revolution was a revolution in the second half of the 18th century, during which the 13 original colonies that today form an area along the American east coast seceded from Britain and established the United States of America as a federal republic.

The American Revolution brought about a number of major intellectual and social changes in young American society, particularly the interest in a Republican government. The American patriots were strongly influenced by the ideas of the Enlightenment; they were against autocracy and did not see the French form of government as a viable solution. In some colonies there were heated debates over the role of democracy in the organization of the state. The change of public opinion towards a republican government and a gradually expanding democracy brought about great changes in the structure of society and laid the foundation for the central ideas by which the United States is still governed.

4 0
3 years ago
Companies support the adoption of international financial reporting standards because
I am Lyosha [343]
<h2>IFRS brings transparency, accountability and efficiency to finanacial market across the globe.</h2>

Explanation:

IFRS - International Financial Reporting Standards

Transparency:

  • Done by enhancing the

            a) international comparability

             b) quality of financial information,

  • enabling investors to make "economic decisions"

Accountability:

  • It strengthens this aspect by reducing the information gaps

Efficiency:

  • Helps investors to identify market opportunities
  • Alert about the risks across the world
  • lowers the Capital cost
3 0
4 years ago
Large investments in old technology and incompatiblility of new and old technologies with each other are the main reasons compan
Ede4ka [16]

Answer:

Design competition

Explanation:

Competition is said to occur when there is rivalry between business organisations that offers the same product and services. This results in struggle for profit, market share growth as well as revenue achievement.

Design competition is employed by the organization who wants to have a cutting edge advantage over rival companies that produces the same product. This dine by changing production line, technology, product size and quality e.t.c.

However, various barriers hinders Design competition. For instance, large investment in old technology will make decisions to take up new technology a hard one to take.

3 0
4 years ago
A manager who threatens to withhold support or rewards is using _____ as a political tactic.a. inducementb. coercionc. persuasio
DanielleElmas [232]

Answer:

b. coercion

Explanation:

A manager who threatens to withhold support or rewards is using coercion as a political tactic. Employees who work under a coercive management, are forced to follow orders and face a harsh and negative work environment that often leads employees to look for other jobs. Managers who practice coercion feel powerful and might but they don't realize how much damage it causes in the long run for the organization.

4 0
4 years ago
A convenience store owner in Philadelphia was worried that the implementation of the 1.5 cents per ounce tax on sweetened bevera
bagirrra123 [75]

Answer:

Elastic- D

Explanation:

When the demand of a product is said to be elastic, it means the price and other factors have a large effect on the quantity purchased by consumers. An increase in price will produce an effect where the quantity purchased decreases.

Elastic demand as opposed to inelastic demand indicates that the consumers can do without that product and can afford to do comparisons before shopping as there is no desperation for the product.

5 0
3 years ago
Other questions:
  • A cement manufacturer has supplied the following data: Tons of cement produced and sold 320,000 Sales revenue $ 1,024,000 Variab
    12·1 answer
  • Calculate the cash dividends required to be paid for each of the following preferred stock issues: Required: The semiannual divi
    14·1 answer
  • The demand curve is Qd = 1,600 – 50P and the supply curve is Qs = 1,200 + 150P. Calculate the equilibrium quantity. Group of ans
    5·1 answer
  • Ignoring issues of the Statute of Frauds, is there a contract for the sale of Vinny’s Celica? Yes, between Vinny and Oscar for $
    14·1 answer
  • Are wages in the United States increasing or decreasing? Explain your answer.
    9·1 answer
  • Peter's Audio Shop has a cost of debt of 7%, a cost of equity of 11%, and a cost of preferred stock of 8%. The firm has 104,000
    12·1 answer
  • The ability to conduct financial transactions through a smartphone is known as
    13·2 answers
  • The scores you receive on the ACCUPLACER tests determine what?
    14·2 answers
  • How do you feel about your pizza delivery person knowing your personal information. would you order pizza from this restaurant?
    12·1 answer
  • Account Balances
    7·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!