What will be the loan balance after three years

Assignment Help Finance Basics
Reference no: EM132395400

Please help me solve using excel or technology. What formulas should be used?

A 3/1 ARM is made for $150,000 at 7 percent with a 30-year maturity.

a. Assuming that fixed payments are to be made monthly for three years and that the loan is fully amortizing, what will be the monthly payments? What will be the loan balance after three years?

b. What would new payments be beginning in year 4 if the interest rate fell to 6 percent and the loan continued to be fully amortizing?

c. In (a) what would monthly payments be during year 1 if they were interest only? What would payments be beginning in year 4 if interest rates fell to 6 percent and the loan became fully amortizing?

Reference no: EM132395400

Questions Cloud

What is the implied 1-year forward rate 1-year : What is the implied 1-year forward rate 1-year from now if the 1-year rate is 6% and the 2-year rate is 8%?
What is the current market price of the bond : The market requires an interest rate of 7% on these bonds. What is the current market price of the bond ?
Use the dataset factor-hair-revised : The objective of the project is to use the dataset 'Factor-Hair-Revised.csv' to build an optimum regression model to predict satisfaction.
Estimate the required return based on capm : Estimate the required return based on CAPM, based on the following assumptions:
What will be the loan balance after three years : A 3/1 ARM is made for $150,000 at 7 percent with a 30-year maturity.
Lump-sum amount instead of the annuity : What rate of return would Cindy need to break even if she took the lump-sum amount instead of the annuity? Could solve with financial calculator.
Yield-to-maturity approach to bond pricing : Assume that the yield-to-maturity approach to bond pricing is appropriate. What is the intrinsic value of the bond right now?
Would you suggest changes or modifications in the statement : Would you suggest changes or modifications in the statement? If so, briefly describe those modifications and your reason for suggesting them.
What is the maximum additional decrease : Assuming a 30% maintenance margin requirement, what is the maximum additional decrease in the price of LMNP that would allow you to maintain an account status

Reviews

Write a Review

Finance Basics Questions & Answers

  Funds to different governmental units

During a budget speech, the Minister for Finance will give detailed appropriations (allocations) of funds to different governmental units.

  Required rate of return-risk adjusted return

What is the required rate of return for a stock whose beta is 1.3, the risk free rate is 2%, and the market rate of return is 7% (r(i) = r(f) + (r(m) - r(f)) X β)?

  Key difference between a fee-for-service plan and episode

Determine a key difference between a fee-for-service plan and an episode of care payment plan, and indicate the plan that you believe to be most advantageous for the majority of patients. Provide support for your rationale

  What will the operating cash flow be

What will the operating cash flow be if output rises to 13,400 units? (Do not round intermediate calculations. Round your answer to 2 decimal places.

  Based on the lecture and webtext materials

Based on the lecture and Webtext materials, address the following:

  Managing an international company and domestic company

What are the differences between managing an international company and managing a domestic company?What functions of management are different in an international company as compared to a company in the US?What function of management is the most im..

  Calculate rnoa for the given year

Leveraging Equations (Easy) The following information is from reformulated financial statements (in millions).

  What is the most it could spend on capital expenditures

(Residual dividend policy) FarmCo, Inc. follows a policy of paying out cash dividends equal to the residual amount that remains after funding 40 percent of its.

  Dual effects on balance sheet equation cement plus a firm

dual effects on balance sheet equation cement plus a firm specializing in building materials engaged in the following

  Contrast the three primary categories of cash flows

Contrast the three primary categories of cash flows provided in the statement of cash flows. Your response should be at least 250 words in length

  Do you think 3000 for 2-3 pages is okaydraft your financial

do you think 30.00 for 2-3 pages is okaydraft your financial analysis report of apple inc including the following six

  How the resulting financial statements would be misstated

Ordered $50,000 of inventory on December 29, 2011. The goods were shipped on December 30, 2011, with the terms FOB shipping point. Dallas received the inventory on January 4, 2012.

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