Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. finance
  3. develop an amortization schedule for a 5-year loan

Develop an amortization schedule for a 5-year loan of $25,000 at an interest rate of 7.5%,...

Free

80.2K

Verified Solution

Question

Finance

Develop an amortization schedule for a 5-year loan of $25,000 atan interest rate of 7.5%, assuming equal annual installments at theend of each year. Use the same format that we used in class.

Please show work in Excel

Answer & Explanation Solved by verified expert
4.1 Ratings (574 Votes)

Computation of equal payment
$6,179.12 =PMT(7.5%,5,-25000,0,0)
Amortization table as below
i ii iii=ii*7.5% iv v=ii+iii-iv
Year Beginning loan amount Interest Annual installment Ending loan amount
0 25000
1                                   25,000.00 1,875.00                  6,179.12                    20,695.88
2                                   20,695.88 1,552.19                  6,179.12                    16,068.96
3                                   16,068.96 1,205.17                  6,179.12                    11,095.01
4                                   11,095.01      832.13                  6,179.12                      5,748.02
5                                     5,748.02      431.10                  6,179.12                                  -  

Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Zin AI - Your personal assistant for all your inquiries!
Become a Member

Transcribed Image Text

Develop an amortization schedule for a 5-year loan of $25,000 atan interest rate of 7.5%, assuming equal annual installments at theend of each year. Use the same format that we used in class.Please show work in Excel

Other questions asked by students

Q

Water heater In a water heater, tap water with the temperature 10 degrees celcius is heated to...

Physics
Q

Planet Lex is four times as massive as the Earth and has a radius four times...

Physics
Q

the figure shown a uniform disc of mass 2m and radius 12 is lying at...

Physics
Q

In the current year Randa Merchandising Incorporated sold its interest in a chain of wholesale...

Basic Math
Q

A recent study found that 42 of all Americans support stricter environmental regulations Let x...

Statistics
Q

TreeHold Corp.designs and builds custom harvesting equipment for logging companies across Canada. The...

Accounting
Q

A company has the following account balances at December 31, 2020: ...

Accounting
Q

Assume that the Gamma partnership agreement gave Steely 60% and Breck 40% of partnership income...

Accounting
Q

Marry and Max had adjusted gross income of 358000. They have itemized deductions of $20,000...

Accounting
Q

Date Name Class ENAMM 19. A remotely possible loss from a lawsuit is not reported...

Accounting
Q

Help me make a gap analysis Internal Location to NYC...

Accounting
Q

Required information [The following information applies to the questions displayed below.] Kubin...

Accounting