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: Flex 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

Accounting
1.2K views

Limo Ltd is a small family owned company that has beensuffering from the credit...

Biology
1.2K views

Using appropriate terminology, explain how homologous structures such as the limbs of humans, cats, whales and...

Physics
1.2K views

A wind turbine is initially spinning at a constant angular speed. As the wind's strength gradually...

Basic Math
1.2K views

Sellect the appropriate equation that matches the graph 2y 2 3 3y 12 3

Basic Math
1.2K views

If the speed limit is 50 miles per hour and a person s trip takes...

Basic Math
1.2K views

You are testing the null hypothesis p = 0.4 and will reject this hypothesis if...

Calculus
1.2K views

We also must make a substitution for the limits of integration in the definite integral...

Accounting
1.2K views

1. what is the business model of Loblaw companies? 2. State it's Stakeholder Analysis.

Accounting
1.2K views

Present and future value tables of $1 at 3% are presented below: 24 nim 5...

Accounting
1.2K views

Imogen then asks you to perform the following steps in MYOB to identify the field...

Accounting
1.2K views

Help Save & Exit Submit RecRoom Equipment Company received an $9,600, sik-month, 6 percent note...

Accounting
1.2K views

Please use the financial statements of Northern Trust Corporation. Refer to the companys audit opinion...