Calculation of the monthly instalment

Assignment Help Accounting Basics
Reference no: EM13930345

You are required to work the following problem, using compound interest techniques. You should model your answer on the text approach in Chapter 5.

On 4 January, 2016, John Brown purchased a home for $900,000. He paid a deposit of $200,000 and on the same day borrowed the balance of the purchase price from the ABC Bank at an interest rate of j12 = 6%, that is, at  a nominal interest rate of 6% per annum, compounded monthly (12 times a year). He agreed with the bank that the loan was to be repaid over a period of 25 years, by equal monthly instalments of $4,510.11, each instalment consisting of part interest and part principal. Monthly repayments will be made on 4th day of each month over this period, with the first instalment due on 4th February, 2016.

REQUIRED:

You are required to answer the following questions. Show all workings, and show all answers correct to the nearer cent. Accuracy and presentation are important.

(a) Verify the bank's calculation of the monthly instalment of $4,510.11.

(b) Assume that all monthly loan repayments are made on the due date. On 4 January, 2019, after payment of the monthly instalment due that day, what will be the amount of loan still outstanding, that is, remaining to be repaid to the bank? [Assume that interest rates are unchanged.)

(c) Over the following  12 months (ending 4 January, 2020, and including the instalment due on that date), all monthly repayments are made on time. What would be the amount of interest paid over that 12 months period?

(d) Calculate the amount of loan principal to be repaid over the year ending 4 January, 2020, assuming that all instalments are paid on the due dates?

(e) On 4 January, 2020, after repayment of the instalment due that day, mortgage interest rates rise to j2 = 7.2% per annum, that is 7.2% per annum, compounded half-yearly. The bank decides to increase the monthly home loan repayment instalment, so that at the new interest rate, the loan will be completely repaid at the end of the original term. What will be the new monthly repayment instalment?

(f) On learning the amount of the increased instalment (from part (e)), John Brown advises the bank that he cannot afford to pay any increased instalment. The Bank decides to allow John Brown to continue to repay the loan by the same level of monthly repayments, but advises John Brown that the term of the loan will be increased as kit will take longer to repay the Loan. Calculate the time required to repay the loan, in years and months (at the new interest rate) if the loan instalment remains unaltered ($4,510.11).

(g) In part (f), what will be the amount of the final monthly repayment?

(h) Suppose that on 4 January, 2022, loan interest rates rise further to J4 = 9.6% per annum, that is 9.6% per annum, compounded quarterly. John Brown advises the bank that he cannot afford to pay any higher instalment. If the bank agrees to John brown's request, calculate how long it will take before the loan is repaid at the new higher interest rate.

(i) Interpret your answer to part (h). What does it mean? Explain carefully.

(j) Drawing on your knowledge of the Sydney housing market in recent years, advise John Brown and the Bank how they should deal with the situation they are faced with in (h) and (i) above

Reference no: EM13930345

Questions Cloud

Describe how unintended consequences may arise : Describe two separate behaviours that would be good candidates for the use of an antecedent intervention through either the use of Non-Contingent Reinforcement (NCR) or the High Probability Request Sequence (HPRS).
The best way to organize a review of the literature : The best way to organize a review of the literature is: Chronologically, with the earliest research first. Chronologically, with the most recent research first. Thematically, with an emphasis on how the literature relates to your question. Critically..
Determine the minimum coefficient of static friction : Determine the corresponding normal force N between the two boards if motion impends at all surfaces and determine the minimum coefficient of static friction
Do the calculations from requirements b and c : Do the calculations from Requirements b and c confirm your speculations in Requirement a?
Calculation of the monthly instalment : You are required to answer the following questions. Show all workings, and show all answers correct to the nearer cent. Accuracy and presentation are important. (a) Verify the bank's calculation of the monthly instalment of $4,510.11.
What is the correlation between an index of civic-mindedness : "What is the correlation between an index of civic-mindedness and years of involvement in local organizations and charities among members of city councils of selected midsized cities in the northeastern United States?"
Delineate the main therapeutic goals for this client : Identify a theoretical model to follow, and determine the next steps you would take in working with this client. Include a rationale for how your identified plan relates to the particular theory you chose to follow.
Analysing the professional attributes and scope of practice : Write a 1000 word essay discussing and analysing the professional attributes and scope of practice that differentiates the specialty nurse in your elective.
What two items are most responsible for the difference : What two items are most responsible for the difference between Target's net income and its cash flow from operating activities in 2010?

Reviews

Write a Review

Accounting Basics Questions & Answers

  How much control does fed have over this longer real rate

Hubbard argues that the Fed can control the Fed funds rate, but the interest rate that is important for the economy is a longer-term real rate of interest.   How much control does the Fed have over this longer real rate?

  Coures:- fundamental accounting principles

Coures:- Fundamental Accounting Principles: - Explain the goals and uses of special journals.

  Accounting problems

Accounting problems,  Draw a detailed timeline incorporating the dividends, calculate    the exact Payback Period  b)   the discounted Payback Period. the IRR,  the NPV, the Profitability Index.

  Write a report on internal controls

Write a report on Internal Controls

  Prepare the bank reconciliation for company

Prepare the bank reconciliation for company.

  Cost-benefit analysis

Create a cost-benefit analysis to evaluate the project

  Theory of interest

Theory of Interest: NPV, IRR, Nominal and Real, Amortization, Sinking Fund, TWRR, DWRR

  Liquidity and profitability

Distinguish between liquidity and profitability.

  What is the expected risk premium on the portfolio

Your Corp, Inc. has a corporate tax rate of 35%. Please calculate their after tax cost of debt expressed as a percentage. Your Corp, Inc. has several outstanding bond issues all of which require semiannual interest payments.

  Simple interest and compound interest

Simple Interest, Compound interest, discount rate, force of interest, AV, PV

  Capm and venture capital

CAPM and Venture Capital

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd