Spreadsheet Exercise
let me know if you have any questions
Your company is considering manufacturing protective cases for a popular new smart-phone. Management decides to borrow $200000 from each of two banks First American and First Citizen. On the day that you visit both banks the quoted prime interest rate is 7%. Each loan is similar in that each involves a 60-day note with interest to be paid at the end of 60 days.
The interest rate was set at 2% above the prime rate on First Americansfixed-rate note. Over the 60-day period the rate of interest on this note will remain at the 2% premium over the prime rate regardless of fluctuations in the prime rate.
First Citizen sets its interest rate at 1.5% above the prime rate on itsfloating-rate note. The rate charged over the 60 days will vary directly with the prime rate.
TO DO
Create a spreadsheet to calculate and analyze the following for the First American loan:
Next create a spreadsheet to calculate the following for the First Citizen loan: