User Account

All Pages

Calculate the monthly mortgage payment of principal

Assignment Help Accounting Basics
Reference no: EM131195807

Develop an assessment of each of the following problems:

1. Calculate the monthly mortgage payment of principal and interest for the a loan with an initial balance of 150,000, an annual stated interest rate of 6%, and 30 years to maturity. Use Excel to develop this response and present your result within a separate page of the spreadsheet.

2. Develop the amortization table for the loan outlined in problem 1. Use an Excel spreadsheet to develop and present this table. Present this result in a separate page of the spreadsheet.

3. Further, given the structure of problem 1, develop a summary table showing how the monthly payment would adjust for all options with an interest rate at 5%, 6% and 7% as well as a maturity at 15 years, 20 years and 30 years. Use Excel to develop and present this summary table. Present the results in a separate page of the spreadsheet.

Reference no: EM131195807

Questions Cloud

Johnny cake weighted-average tax rate : Assume Johnny Cake's weighted-average tax rate is 34 percent, its next dividend is expected to be $3 per share, and all future dividends are expected to grow at 6 percent per year, indefinitely.
Employees for a new production line : Assignment: You are a mid-level manager for a large firm. Your task is to hire 20 new employees for a new production line. Prior to execution, you must report to your district manager on what your plan is to work through the hiring process to ensu..
Determining the unearned rent revenue : On September 1, 2012, Huntington collected six months of rent worth $9,000 on storage space. At that date, Zimmerman debited Cash and credited Unearned rent Revenue for $9,000.
How the development and use of new medical technology : Explain how the development and use of new medical technology, such as new diagnostic procedures and treatments, has increased spending and accounts for one-half to two-thirds of the increase in healthcare spending in excess of general inflation.
Calculate the monthly mortgage payment of principal : Calculate the monthly mortgage payment of principal and interest for the a loan with an initial balance of 150,000, an annual stated interest rate of 6%, and 30 years to maturity.
Prepare revaluation account and capital accounts : Prepare Revaluation account, Partners' Capital accounts and Balance Sheet of X & Y after Z's retirement. Also prepare Z's Loan account till it is fully paid.
What was the nature of the fraud at adelphi : What was the nature of the fraud at Adelphi as it related to debt obligations and its stockholders' equity accounts?
Southwest airlines-employee education takes flight : Go to the Chief Learning Officer's (CLO) Website and read the article titled "Southwest Airlines: Employee Education Takes Flight". Next, determine if Southwest's method of training is an effective way to conduct training. Support your position. Pr..
Is it ethical for someone to refuse the vaccine : Do you think that for more common diseases, for example measles, that it is ethical for the state to allow people to refuse vaccines (even for religious grounds)? What if their refusal can harm others who cannot have the vaccine, such as people wh..

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.

  Theory of interest - term structure of interest rates

Term Structure of Interest Rates

  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!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

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