Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Assume that your group represents the Credit Manager of a North Vancouver Credit Union and that Mr. Wayne Gretski, on his way through Vancouver to

image text in transcribed
image text in transcribed
Assume that your group represents the Credit Manager of a North Vancouver Credit Union and that Mr. Wayne Gretski, on his way through Vancouver to the 2022 Olympics, has asked that you analyze the history of his previous and current mortgage transactions. a) Exactly 10 years ago, Mr. Wayne Gretski purchased a beautiful condo at Whistler for $695,000 and made a down payment of S275,000. The balance was mortgaged at the Canada Bank at 4.15% compounded semi-annually with monthly payments over 25 years. The interest rate was fixed for a 5 year term, and lump sum payments were allowed at the end of each 5 years without penalty Calculate the monthly payment for the first 5 years. ROUND UP TO THE NEXT CENT 11) Construct an amortization schedule for the first 60 months. (A schedule showing only the first 3 months, and months 57 to 60 inclusive, with 60 month totals is also required.) 111) Calculate the principal outstanding at the end of the first 5 years. 1V) What percentage of the first five years total monthly payments went to reduction of the debt, and what percentage went to interest? What percentage of the debt has been paid off by the first five years of payments? 1) b) Exactly five years ago, Wayne made a lump-sum payment of $105,000 (in addition to the regular payment), and the interest rate was also changed to 4.65% compounded semi-annually c) D Calculate the amount being refinanced. 11) Calculate the monthly payment for the second 5 year period. ROUND UP TO THE NEXT DOLLAR How much total interest did Wayne pay in the past two years? Wayne's mortgage has just come up for further renewal. He has decided to take advantage of your relatively low rates and wishes to investigate tranferring it to your North Vancouver Credit Union branch that charges 5.25% compounded monthly payable over 15 years. Calculate the size of the principal balance being refinanced. ii) Calculate the size of the new monthly payment 111) Wayne seems amazed that he has only repaid a small fraction of his original loan. You will draw a large scale, fully labelled graph that visually explains to Wayne how the loan has been amortized over the past ten (10) years. You are only expected to plot the annual balances owing

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

Accounting

Authors: Warren S. Carl

23rd Edition

0324555865, 978-0324555868

More Books

Students also viewed these Accounting questions

Question

4. Make recommendations on steps to take to melt the glass ceiling.

Answered: 1 week ago

Question

1. Discuss the potential legal issues that relate to training.

Answered: 1 week ago