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.
-
Determine the order n of the Maclaurin polynomial for ex that is required to approximate ex to five decimal places, that is, so that | Rn(1) | ( 0.000005?
-
How would the initial payment change if the payments increase by 5 percent each year instead of 7.5 percent?
-
Assuming the same data as given in problem 9, was the well in each case profitable? Discuss your answer. Problem 9:- Property cost (acquisition cost). Drilling cost (one well). Estimated completion...
-
Weather Balloons, Inc., makes reusable weather-detecting balloons. Because of a recent recession, management has ordered that standard costs be recomputed. New direct materials price standards are...
-
In Milestone Two, you will review the Final Project Client Information document to identify all beneficiaries and discuss potential tax ramifications of receiving inherited property. In addition, you...
-
Arndt, Inc., reported the following for 2024 and 2025 ($ in millions): a. Expenses each year include $30 million from a two-year casualty insurance policy purchased in 2024 for $60 million. The cost...
-
Derive the expression of air standard efficiency and mean 3+4=7 [CO3] effective pressure for Diesel cycle. The stroke and cylinder diameter of a diesel cycle are 150 mm and 125 mm respectively. If...
-
A square loop with sides 1 2 cm by 1 2 cm has 2 5 turns of wire and is in a magnetic field of strength 4 . 2 x 1 0 ^ - 2 T with its axis perpendicular to the direction of the field. if it is rotated...
-
How do post-transcriptional and post-translational regulatory mechanisms, such as microRNA-mediated gene silencing and protein modification, contribute to the fine-tuning of developmental processes,...
-
Grandin Inc. is evaluating its dividend policy. It has a capital budget of $625,000, and it wants to maintain a target capital structure of 60% debt and 40% equity. The company forecasts a net income...
-
recording a lon term lease as an operating lease as opposed to a capital lease what will cause for a lease are the debt to equity will be higher than total asset turnover? Explain.
-
Consider a reaction that has a negative AH and a positive AS. Which of the following statements is true? This reaction will be nonspontaneous only at high temperatures. This reaction will be...
-
Use Word to organize your answers. Your answers should include a list of items A-J followed by the name associated with each letter of the alphabet. Example (these are not accurate answers):...
-
On average there are four traffic accidents in a city during one hour of rush-hour traffic. Use the Poisson distribution to calculate the probability that in one such hour there arc (a) No accidents...
-
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...
-
Which of the following statements regarding collusive frauds and financial crimes is most accurate? 1. Internal controls are more likely to be effective in the detection versus the prevention or...
-
Which of the following is not considered a complex fraud? 1. Embezzlement 2. Local, street corner drug trafficking 3. Domestic terrorism financing 4. International money laundering
-
Select the statement that is least accurate: 1. Following the money can only be performed if those assets remain in their original identifiable form as they flow from place to place or person to...
Open Economics Economics In Relation To Other Disciplines 1st Edition - ISBN: 0415746574 - Free Book
Study smarter with the SolutionInn App