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
Thepotemich [5.8K]
3 years ago
13

Excel Online Structured Activity: Amortization schedule The data on a loan has been collected in the Microsoft Excel Online file

below. Open the spreadsheet and perform the required analysis to answer the questions below. Open spreadsheet a. Complete an amortization schedule for a $15,000 loan to be repaid in equal installments at the end of each of the next three years. The interest rate is 12% 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: % %
Business
1 answer:
musickatia [10]3 years ago
7 0

Answer:

a. Ending balance in year 3 = $0

b.

            % Interest      % Principal

Year 1:      28.82%             71.18%

Year 2:     20.28%            79.72%

Year 3:      10.71%             89.29%

Explanation:

a. Complete an amortization schedule for a $15,000 loan to be repaid in equal installments at the end of each of the next three years. The interest rate is 12% compounded annually. Round all answers to the nearest cent.

Note: See part a of the attached excel file for the calculations.

In the excel function, the yearly payment is calculated by using PMT function in Excel: =PMT(12%,3,-15000,,)

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.

Note: See part b of the attached excel file for the calculations.

Download xlsx
You might be interested in
Theoretically, a company comparing multiple projects with similar investment requirements and durations would select projects wi
Elden [556K]

Answer:

D.)

the highest IRR

Explanation:

Here are the options to the question :

A.)

the IRR that is closest to zero

B.)

a negative IRR

C.)

the lowest IRR

D.)

the highest IRR

IRR is a capital budgeting method.

Internal rate of return is the discount rate that equates the after-tax cash flows from an investment to the amount invested

The higher the IRR, the more profitable the project is.

In the absence of certain restrictions, the project with the highest IRR should be chosen

4 0
3 years ago
What is the most likely effect of the development of XBOX with DVD capabilities on the DVD player industry? a. ​decreased price
Shkiper50 [21]

Answer:

The correct answer is letter "B": ​Increased price elasticity of demand for the DVD player industry because XBOX are substitutes.

Explanation:

Price elasticity of demand reflects the changes in quantity demanded for a good or service as a result of changes in price. It is calculated by dividing the percentage change in quantity demanded by the percentage change in price. If the result is equal to or greater than one (1) the demand is elastic.<em> It means a minimum change in price has a major impact on the quantity demanded volume. </em>

Thus, <em>if XBOX implements DVD features, DVD players will face an increase in their price elasticity of demand because changing DVD players' prices could change their quantity demanded by far because consumers will prefer purchasing an XBOX which is a substitute.</em>

7 0
3 years ago
​sheldon goes to the grocery store to buy a few items, and when he gets there he can remember only the last few things that he w
jenyasd209 [6]
The answer is recency effect. The recency effect happens when you only remember the things or events that just happened in a recent time.In this case, Sheldon is showing the recency effect because he only remembered the last part of the list that he was going to buy. If Sheldon had remembered the first part, then he is experiencing the Primary effect, which is the opposite of recency effect
5 0
3 years ago
Read 2 more answers
Who is president <br> Of the United States of America
Hoochie [10]
Barack Obama is the President of the US
4 0
3 years ago
Read 2 more answers
Is it wise for a firm to employ a worker at $20 per hour when another worker does the same job for $10 per hour? It would be a r
grandymaker [24]
The right answer for the question that is being asked and shown above is that: "The government will pay firms to give some workers extra pay to increase the total economy." <span>Is it wise for a firm to employ a worker at $20 per hour when another worker does the same job for $10 per hour? </span>
6 0
3 years ago
Other questions:
  • A publisher of photography books finds that it is cost-effective to print 10,000 or more at a time. But a bookstore orders only
    15·1 answer
  • Dinklage Corp. has 7 million shares of common stock outstanding. The current share price is $79, and the book value per share is
    6·1 answer
  • When preparing the statement of cash flows by the indirect method, if current liabilities increase the difference is
    14·2 answers
  • Which of the following is a depository financial institution
    12·1 answer
  • Headrest reduce the risk of neck injury in a rear end collision true or false
    8·1 answer
  • If a firm has high current and quick ratios, this always is a good indication that a firm is managing its liquidity position wel
    7·1 answer
  • A project has an initial cost of $50,000. The incremental inflows associated with the project are $20,000 in year one, $15,000 i
    8·1 answer
  • Derek's new office is undergoing a minor renovation and he cannot conduct business in the location for approximately six months.
    14·1 answer
  • GiftBasket has successfully created a higher perceived value in the e-commerce industry, though it offers the same products at s
    14·1 answer
  • ABC Motors ordinarily deals in used cars and does some amount of repair work. Robby entrusted his automobile to ABC Motors to ha
    13·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!