Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Just wondering if this is correct on excel. The ending balance is correct I think but i not sure why its highlighted in red. $7,500

Just wondering if this is correct on excel. The ending balance is correct I think but i not sure why its highlighted in red. image text in transcribed
image text in transcribed
$7,500 of Payments: 4 Monthly Rate 20% Mortgage Payment: 0.016666667 $2,897.17 1 Beginning Balance Payment $7,500 $6,102.83 $4,426.23 $2.414.31 Interest Principal Ending Balance 1500 $1,397.17 $6,102.83 $1,220.57 $1,676.60 $4,426.23 $895.25 $2,011.92 $2,414.31 $482.86 $2,414.31 (S0.00) $2,897.17 $2,897.17 $2,897.17 $2,897.17 3 4 A13. (Amortizing a loan) Create a loan amortization schedule for borrowing 57500 at an interest rate of 20% per year, to be paid off in four equal annual payments

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting Ledger Book

Authors: Alpha Planners Publishing

1st Edition

B09VWKPJSG, 979-8432472564

More Books

Students also viewed these Finance questions

Question

Where should the responsibility for forecasting future usage lie?

Answered: 1 week ago