How much is the original monthly repayment

Assignment Help Finance Basics
Reference no: EM132607375

Would you please provide manual calculations with formulars as i dont need excel.

Now that she has accumulated a deposit of $100,000, Julie wishes to use this deposit and take out a housing loan to purchase a home. The home costs $600,000. The loan is to be repaid in equal monthly instalments over a term of 25 years. Julie recalls that the interest rate quoted by the bank is an annual nominal rate of 3.6%pa compounded monthly. After 5 years (60th repayment just about to be made), the bank announces the interest rate will change to an annual nominal rate of 2.8%pa compounded monthly.

(i) How much is the original monthly repayment? $2,530.01

(ii) How much is the owed at the time of the interest rate fall?

(iii) Assuming the new repayments are calculated after the 60th repayment has been made, provide Julie with a repayment schedule using excel.

Reference no: EM132607375

Questions Cloud

Calculate the break-even units for the month : Chill Ltd sold 125 000 of its deluxe rooms last month in Cape Town. The variable cost involved in a one-night
How do find the risk free rate : What is the Weighted average cost of capital (WACC) for the company? What is the leverage (total debt/equity ratio) for the company?
Compose a report inclusive of research and data analysis : Evaluate research and data that can help answer the research question and support a hypothesis. Compose a report inclusive of research and data analysis.
What type of control procedures were ignored at Daiwa : What type of control procedures were ignored at Daiwa? What kind of controls could have been instituted that would have prevented the problems at Daiwa
How much is the original monthly repayment : Now that she has accumulated a deposit of $100,000, Julie wishes to use this deposit and take out a housing loan to purchase a home.
Prepare an analysis of the composition of return : Prepare an analysis of the composition of return on common equity describing the advantage or disadvantage accruing to common shareholders
Develop a material management strategy and protocols : Develop a material management strategy and protocols to be put in place to achieve these objectives
Explain the some of ethical issues that nike facing in case : Should we inflict western values on this society? Bring in the concepts of social responsibility, integrity and other business ethics practices.
Define how the pmo adds project management : Explain how the PMO adds project management and enterprise value. Describe the PMO competency continuum framework and its five stages. Illustrate the PMO.

Reviews

Write a Review

Finance Basics Questions & Answers

  Assess the risk associated with its forecasts

A firm evaluates its breakeven points and degrees of leverage to assess the risk associated with its forecasts.

  What types of businesses might it make sense to have

For what types of businesses might it make sense to have more independent contractors, than employees? Why?

  What is the value of the investment timing option

The Bush Oil Company is deciding whether to drill for oil on a tract of land that the company owns. The company estimates that the project will cost $6 million.

  Instructive regarding organizational financial health

In a similar vein, which financial ratio(s) provide the most insight into financial viability?

  Property exposure in order to diversify

Grace has an investment horizon of one year and wants to gain some property exposure in order to diversify

  Explain and defend why you agree or disagree

The company's CEO has stated if the company increases the amount of long term debt so the capital structure will be 60% debt and 40% equity.

  What is the probility that the return on the stock

What is the probility that the return on the stock in any one year will be lower than -9.7%

  Determining the kinds of programing

There are definitely trends in what funders are seeking to fund. What kinds of programing do you think are currently at the top of the trend curve, and why?

  What is the free cash flow model

What is the free cash flow model to detect the fair price of a stock?

  Call option on gold with a strike price

If you pay a premium of $27.5 today per option and the interest rate per year is 3.4%, how much is your payoff if the spot price of gold in one year is $1,650?

  Computing efficient frontier for strategic decision

Computing efficient frontier for strategic decision and Plot the graph of the resulting portfolio returns and standard deviations

  Computation stock price and return by gordon growth model

Computation stock price and return by Gordon growth model and The dividend is expected to grow at a constant rate of 6 percent a year

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