Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Corporation Finance Lab- Present Value, Effective rates and Loan Amortization Please try the following problems: 1. ABC Company sells heavy equipment to its customers. The

image text in transcribed
Corporation Finance Lab- Present Value, Effective rates and Loan Amortization Please try the following problems: 1. ABC Company sells heavy equipment to its customers. The price of a new backhoe is S150,000. Bob the builder would like to buy the backhoe, but he cannot afford the cash purchase price. He would like to buy the tractor by putting down S30,000 and paying the balance with an installment note paid with equal annual installments over the next 4 years. Interest rates are 9%. a. Use Excel to determine the payment. b. Do you see that the PV of the note the amount borrowed - PV of 4 payments) c. What is the sales price of the backhoe under the financing arrangement? d. What is the total amount Bob will pay on the note over 4 years. What is the difference between the value of the note and the total to be repaid? Use Excel to create a 4 year amortization schedule. I recommend this format: e. Outstanding Balance Interest Principal Date expense Payment Paid Compute the total interest on the note and compare it to the amount you computed in d. f. Banks often advertise the periodic interest rate. They must disclose the annual rate of interest (simply taking that rate * the number of compounding periods) as well as the effective annual rate of interest. You can use Excel to determine the effective annual rate. The formula is: EAR [I+(APR rate/m)]-1 (where m the compounding periods) 2. The Excel formula (requires analytical tool add-in) Nominal - enter the nominal rate Npery- enter the compounding periods per year EFFECT will give you the effective annual rate Alice's Auto Shop charges an annual interest rate of 8.2% on its loans. The loan payments are made each month . What is the EAR (effective annual rate) on the loan

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

Corporate Treasury And Cash Management

Authors: Robert Cooper

1st Edition

1349512699, 9781349512690

More Books

Students also viewed these Finance questions