Maurice Tutor

(5)

$15/per page/Negotiable

About Maurice Tutor

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:
Algebra,Applied Sciences See all
Algebra,Applied Sciences,Biology,Calculus,Chemistry,Economics,English,Essay writing,Geography,Geology,Health & Medical,Physics,Science Hide all
Teaching Since: May 2017
Last Sign in: 402 Weeks Ago, 2 Days Ago
Questions Answered: 66690
Tutorials Posted: 66688

Education

  • MCS,PHD
    Argosy University/ Phoniex University/
    Nov-2005 - Oct-2011

Experience

  • Professor
    Phoniex University
    Oct-2001 - Nov-2016

Category > Management Posted 01 Jun 2017 My Price 13.00

Mortgage Loan Analysis

Instruction:

 

You are expected to show your working process and discuss your findings in details.

 

  1. You need to work inExcel. Your final report should be well-organized and typed in a WORDfile. Please submit both your WORD report and Excel filesThe style and organization of the project are important.

 

Project 1: Mortgage Loan Analysis: Mr. Johnson plans to buy a new house at Sugar Land in September 2014. The sale price of the house is $366,000. He is going to pay 20% down payments and borrow additional 80% from Wells Fargo with a 20-year, 3.875% fixed-rate mortgage loan. He is expected to pay an equal MONTHLY payment starting from October 2014 for a total of 20 years.

(1) Calculate the required monthly mortgage payment for Mr. Johnson.

(2) Construct the 2014~2020 amortization table for Mr. Johnson.

(3) Mr. Johnson should prepare his 2014 tax filings in early 2015. Estimate the total mortgage interest payments that he can use for his 2014 tax deduction.

 

Project 2: Capital Budgeting Analysis: The CS HighTech is planning a new investment project which is expected to yield cash inflows of $335,000 per year in Years 1 through 5, $266,000 per year in Years 6 through 9, and $218,000 in Years 10 through 15. This investment will cost the company $2,500,000 today (initial outlay). We assume that the firm's cost of capital is 8.5%.

(1) Draw a time line to show the cash flows of the project.

(2) Compute the project??s payback period, net present value (NPV), profitability index (PI), internal rate of return (IRR), and modified internal rate of return (MIRR).

(3) Discuss whether the project should be taken.

Answers

Maurice Tutor
(5)
Status NEW Posted 01 Jun 2017 09:06 PM My Price 13.00

Hel-----------lo -----------Sir-----------/Ma-----------dam----------- Â-----------  -----------Tha-----------nk -----------You----------- fo-----------r u-----------sin-----------g o-----------ur -----------web-----------sit-----------e a-----------nd -----------acq-----------uis-----------iti-----------on -----------of -----------my -----------pos-----------ted----------- so-----------lut-----------ion-----------. P-----------lea-----------se -----------pin-----------g m-----------e o-----------n c-----------hat----------- I -----------am -----------onl-----------ine----------- or----------- in-----------box----------- me----------- a -----------mes-----------sag-----------e I----------- wi-----------ll

Not Rated(0)
Relevent Questions