BUSINESS FINANCE Instruction

BUSINESS FINANCE Instruction: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.BUSINESS FINANCEInstruction:You are expected to show your working process and discuss your findings in details.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.

Our Service Charter

1. Professional & Expert Writers: I'm Homework Free only hires the best. Our writers are specially selected and recruited, after which they undergo further training to perfect their skills for specialization purposes. Moreover, our writers are holders of masters and Ph.D. degrees. They have impressive academic records, besides being native English speakers.

2. Top Quality Papers: Our customers are always guaranteed of papers that exceed their expectations. All our writers have +5 years of experience. This implies that all papers are written by individuals who are experts in their fields. In addition, the quality team reviews all the papers before sending them to the customers.

3. Plagiarism-Free Papers: All papers provided by I'm Homework Free are written from scratch. Appropriate referencing and citation of key information are followed. Plagiarism checkers are used by the Quality assurance team and our editors just to double-check that there are no instances of plagiarism.

4. Timely Delivery: Time wasted is equivalent to a failed dedication and commitment. I'm Homework Free is known for timely delivery of any pending customer orders. Customers are well informed of the progress of their papers to ensure they keep track of what the writer is providing before the final draft is sent for grading.

5. Affordable Prices: Our prices are fairly structured to fit in all groups. Any customer willing to place their assignments with us can do so at very affordable prices. In addition, our customers enjoy regular discounts and bonuses.

6. 24/7 Customer Support: At I'm Homework Free, we have put in place a team of experts who answer to all customer inquiries promptly. The best part is the ever-availability of the team. Customers can make inquiries anytime.