BUSINESS FINANCEInstruction:You are expected to show your working process and discuss your findings in details.You need to work inExcel. Your final report should be well-organized and typed in a WORDfile. Please submitboth 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.
