Question: Seek command in Excel to nd the net borrowing cost for this package by including the annual fee (expressed as a rate p.a. compounded monthly).


Seek command in Excel to nd the net borrowing cost for this package by including the annual fee (expressed as a rate p.a. compounded monthly). Please refer to table 3 for his calculations. Table 3: Jimmy's Excel spreadsheet. _'- Borrowed amount Net borrowing 1. 3388% cost per month Interest rate 3'12 Net borrowing 16.066% cost 3'12 Interest rate per Present value of $346.6621 month the management fee by using net borrowing rate Number of Present value of 8000.00 Number of Loan repayment $80 interestonly for the rst three payments months Management fee Loan repayment $424.2460 for the following 21 months a. [ 3 marks] Give the Excel cell formulae you would use to calculate the value of cells D5 and D6. b. [ 2 mark] Give the Excel cell formulae you would use to calculate the value of cell D3. c. [ 3 mark] Give the Excel cell formula you would use to calculate the value of cell D4. (:1. [ 3 marks] Describe the steps Jimmy used to generate his result in cell D1 using Goal Seek
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
