Kindly do on excel and screenshot with formulas.

1. You are ready to buy a house and you have $50,000 for a down payment and closing costs. Closing costs are estimated to be 3.5% of the loan value. You have an annual salary of $200,000. The bank is willing to allow your housing costs mortgage, property tax, and homeowners insurance to be equal to 28% of your monthly income. You have estimated that property tax will be $1,000/month and homeowners insurance will be $100/month. The interest rate on the loan is 3.9% per year with monthly compounding for a 30-year fixed-rate loan. a. How much money will the bank loan you? b. How much can you offer for the house? c. Create a loan amortization table in Excel and submit the spreadsheet. This should be done with monthly payments.

2. Canine, Inc., has identied an investment project with the following cash ows. If the discount rate is 8 percent for the first 2 years and 6% for the years after, beginning in year 3, what is the future value of these cash ows in Year 5? What is the future value of the cash flows in year 10? What is the present value of the cash flows?

Year Cash Flow 1 $1,075 2 $1,235 3 $1,510 4 $1,965 5 0 6 0 7 $10,000