Question 4 n Face Value Price Interest rate 25 $12,365 $9,714 Question 5 Growth Rate Dividend Equity Cost Purchase price 4.75% $2.78 9.58% Question 6 Re E V Rd D c WACC 14.26% $582,000 $887,200 7.95% $309,875 42.50% Question 7 and 8 Number of year (n) Student Loan (L) Prime rate (Prime) Interest (0) Monthly Payment 9.00 $47,589 0.75% 1.50% 4) Create Excel formula to calculate Interest Rate. (1.5 marks) Face Value 1 Interest Rate - 1 Price = 5) Create Excel formula to calculate Purchase Price. (1.5 marks) (1 + Growth Rate) * Dividend Purchase Price Equity Cost Growth Rate = 6) Create Excel formula to calculate WACC. (2 marks) E WACC * Rd * (1 Tc) + * Re V D V 7) Create Excel formula to calculate student load monthly payment. (4 marks) (i + Prime) (i + Prime) * L * (1 + 2)(n+12) 12 12 Monthly Payment (1 + 12 (i + Prime);(n+12) 1 8) Use Solver function on Q7 to determine the Number of year (n) for the Monthly Payment increased to $600. (2 marks)