Assume that your group represents the Credit Manager of a North Vancouver Credit Union and that...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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. Ⓡ b) c) Exactly 10 years ago, Mr. Wayne Gretski purchased a beautiful condo at Whistler for $760,000 and made a down payment of $295,000. The balance was mortgaged at the Canada Bank at 4.30% 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. i) ii) iv) v) i) ii) iii) Calculate the monthly payment for the first 5 years. ROUND UP TO THE NEXT CENT. 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.) Calculate the principal outstanding at the end of the first 5 years. Exactly five years ago, Wayne made a lump-sum payment of $115,000 (in addition to the regular payment), and the interest rate was also changed to 4.75% compounded semi-annually. i) ii) iii) 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? Calculate the amount being refinanced. 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. Calculate the size of the new monthly payment. 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. 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. Ⓡ b) c) Exactly 10 years ago, Mr. Wayne Gretski purchased a beautiful condo at Whistler for $760,000 and made a down payment of $295,000. The balance was mortgaged at the Canada Bank at 4.30% 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. i) ii) iv) v) i) ii) iii) Calculate the monthly payment for the first 5 years. ROUND UP TO THE NEXT CENT. 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.) Calculate the principal outstanding at the end of the first 5 years. Exactly five years ago, Wayne made a lump-sum payment of $115,000 (in addition to the regular payment), and the interest rate was also changed to 4.75% compounded semi-annually. i) ii) iii) 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? Calculate the amount being refinanced. 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. Calculate the size of the new monthly payment. 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.
Expert Answer:
Answer rating: 100% (QA)
Answer Amount mortgage for 25 years 430 compound interest semi annually with monthly payment Interes... View the full answer
Related Book For
Principles of Corporate Finance
ISBN: 978-0072869460
7th edition
Authors: Richard A. Brealey, Stewart C. Myers
Posted Date:
Students also viewed these accounting questions
-
An L-2 tool steel link in a forging machine is pin connected to the forks at its ends as shown. Determine the maximum load P it can carry without buckling. Use a factor of safety with respect to...
-
Consider a call option with the following characteristics: Stock price: $90.32 Exercise price: $74.51 Risk-free rate: 5.9%, compounded continuously Maturity: 159 days (assume there are 365 days in a...
-
Construct an amortization schedule for a four-year, $10,000 loan at 6% interest compounded annually.
-
When will the gravitational force between you and the Sun be greater-today at noon, or tomorrow at midnight? Defend your answer.
-
The horizontal ground lengths of a four-sided closed polygon traverse were measured as follows: AB = 479.549 m, BC = 830.616 m, CD = 685.983 m and DA = 859.689 m. If the average orthometric height of...
-
4) The theory of constraints uses a different definition of Inventory Cost than traditional cost accounting. Which of these statements are correct? a. Only DM and DL are counted as inventory cost b....
-
Microsoft considers six principles important to the ethical development and deployment of AI: faimess, reliability and safety, privacy and security, inclusiveness, transparency, and accountability....
-
Loblaw Manufacturing has asked you to create a cash budget in order to determine its borrowing needs for the June to October period. You have gathered the following information. April and May sales...
-
A bond with a 8-year duration is worth $1,077, and its yield to maturity is 7.7%. If the yield to maturity falls to 7.57%, you would predict that the new value of the bond will be approximately
-
Neighborhood Supermarkets is preparing to go public, and you are asked to assist the firm by preparing its statement of cash flows for 20X1. Neighborhoods balance sheets at December 31, 20X0, and...
-
Hechter Company's checkbook balance as of December 31, 2020 was P1,750,000. On the same date, Hechter had the following items on its safe, together with 18 blank checks: a. A P70,000 check payable to...
-
What are Pretrial Diversion programs and their purpose? Describe the various types of Pre-trial Diversion programs thatexist (minimum of 4). Include in your analysis of the variety ofprograms the...
-
Describe the role of G-protein coupled receptors (GPCRs) in signal transduction and outline how dysregulation of GPCR signaling can lead to disease .
-
You are given some key financials data for a well-known retailer for the fiscal years 2013 to 2017. Please provide an analysis of the company's performance based on the data provided. FY 2015 FY 2016...
-
Veronica has come in to speak to you as she requires support to help her get through the current situation that she is in. Veronica has recently lost custody of her two (2) children in a nasty...
-
Kamala Harris has been described as the first black VicePresident as well as the first Asian Vice President. Her fatherwas an immigrant to the US from Jamaica, and her mother immigratedto the US from...
-
a taxpayer's business asset was partially destroyed by fire. the taxpayer's adjusted basis of 500000 in the asset. the fair market value was 800000 before the fire and 600000 after.taxpayer did not...
-
DEPARTMENT DATA EMPLOYEE DATA EmployeeNumber FirstName Mary Rosalie Richard George Alan 3 4 5 7 8 9 855555ES 12 13 14 15 16 17 Create the database tables in SQL or ACCESS: 18 19 20 PROJECT DATA Ken...
-
Look again at the spot interest rates shown in question 8. What can you deduce about the one-year spot interest rate in four years if (a) The expectations theory of term structure is right? (b) The...
-
Is it better to exercise a call option on the with-dividend date or on the ex-dividend date? How about a put option? Explain.
-
Indicate what's wrong with the following arguments: (a) As the firm borrows more and debt becomes risky, both stockholders and bondholders demand higher rates of return. Thus by reducing the debt...
-
The weekly payroll for employees of Ryan Company, who work a five-day week, amounts to \(\$ 20,000\). All employees are paid up-to-date at the close of business each Friday. If December 31 falls on...
-
At year-end the adjusting entry to reduce the Unexpired Insurance account by the amount of insurance premium applicable to the current period was accidentally omitted. Which items in the income...
-
Do all transactions involving revenue or expenses require adjusting entries at the end of the accounting period? If not, what is the distinguishing characteristic of those transactions that do...
Study smarter with the SolutionInn App