Finance > QUESTIONS & ANSWERS > AFM 273 F2019 midterm solution. (All)

AFM 273 F2019 midterm solution.

Document Content and Description Below

AFM 273 Midterm Exam Student ID: Date of Exam: Thursday October 24th, 2019 Start Time: 7:00pm End Time: 8:30 Duration: 90 minutes Location: Various Question Outline Available Marks Time Value ... of Money 8 8 Mortgage Analysis 10 10 Bond Analysis 14 14 Industry Analysis 10 10 Comparable Analysis 10 10 Intrinsic Analysis (DCF) 20 20 72 72 Student Name: Record your answers on "Questions" tab Record your answers on "Questions" tab Record your answer on "Questions" tab Record your answer on "Questions" tab Record your answers on "Comp Analysis" tab Record your answers on "Discounted Cashflow" tab ** All shaded answer cells should indicate the formula/function used or referenc** Do not add any rows to the spreadsheet 1 Convert the following rates from an APR with the shown compounding frequency to an EAR. Compounding APR Period EAR 0.5 15% Annually 15.00% 0.5 8% Semi annually 8.16% 0.5 12% Weekly 12.73% 0.5 8% Monthly 8.30% 2 2 Using the annuity formula 0 2 Using the excel function 0 2 0 Pmt 1 2 3 4 5 6 7 A lottery prize offers an annual payment of $10,000 per year payable at the recieved now and the next will be recieved in one year. Calculate the present valrate is 10%. (6 marks) Calculating the present value of each payment seperately using the timline below. 8 9 10 3 A Answer the following questions - It may be helpful to create an amortization schedule 1 1 The EMR is: 1 2 The monthly payments are: (use the annuity formula) 1 3 The monthly payments are: (use the excel function) 1 4 Percentage of the first payment that goes towards interest is: 1 5 The total interest paid during the first 24 payments is: 1 6 The total interest paid over the life of the mortgage is: 2 7 The principal balance outstanding at the end of 10 years is: B With all else remaining constant, explain the impact of amortizing the loan over a shorter p2 4 Bond The monthly payment would increase and the amount of interest paid would decrease. Government of Canada "A" Government of Canada "B" a) Given the information with respect to the above Government of Cana [Show More]

Last updated: 2 years ago

Preview 1 out of 51 pages

Buy Now

Instant download

We Accept: