need Excel formulas

1/4 115% + H FINC 436 HW 03 Complete/answer each of the following problems providing an Excel spreadsheet with the solution to receive full credit. Do not provide just numbers but the formulas in Excel with the right answer. It is required to calculate the cash flows period per period (monthly), the loan amortization schedule payment per payment for the entire term of the loan even if cancelled early, etc. Explain with your own word the calculations you have done step by step; do not just copy a solution you can find online because without formulas or explanation you will not receive any credit. Calculation without formulas and functions in Excel will receive zero points. A message saying calculations were done in a financial calculator are not accepted. 1- Problem 7-2 2- Problem 7-3 3- Problem 7-4 Problem 1 Problem 3 An investor is considering the acquisition of a "distressed property" which is on Northlake Bank's REO Ist. The property is available for $250,000 and the investor estimates that he can borrow $200,000 at 8 percent interest and that the property will require the following total expenditures during the next year. Inspection $ 500 Title Search 1,000 Renovation 13,000 Landscaping 800 Loan interest 12,800 Insurance 1,800 Property taxes 6,000 Selling expenses 8,000 a) The Investor is wondering what such a property must sell for after one year in order to earn a 20 percent return (IRR) on equity. What other issues must he consider? b) The lender now is concerned that if the property does not sell, he may have to carry the property for one additional year. He believes that he could rent it and realize net cash flow before debt service of $1,200 per month. However, he would have to make an additional $12.800 in interest payments on his loan during that time, and then sell. What would the price have to be at the end of year 2 in order to earn a 20 percent IRR on equity? Expectations: al Calculate the price at which you will make a 20% return on your equity selling one year later Explain step by step and the log of each step in your calculation List in the spread theet the cashflowi mooth by month and the calculation of the IRA that results in a 20% return on your equity b) repeat the what you did in part) for two years incorporating the new information about year 2 trental income for example) List in the spreadsheet the cathows month by month and the calculation of the IRR that results in 20% return on your equity 1/4 115% + H FINC 436 HW 03 Complete/answer each of the following problems providing an Excel spreadsheet with the solution to receive full credit. Do not provide just numbers but the formulas in Excel with the right answer. It is required to calculate the cash flows period per period (monthly), the loan amortization schedule payment per payment for the entire term of the loan even if cancelled early, etc. Explain with your own word the calculations you have done step by step; do not just copy a solution you can find online because without formulas or explanation you will not receive any credit. Calculation without formulas and functions in Excel will receive zero points. A message saying calculations were done in a financial calculator are not accepted. 1- Problem 7-2 2- Problem 7-3 3- Problem 7-4 Problem 1 Problem 3 An investor is considering the acquisition of a "distressed property" which is on Northlake Bank's REO Ist. The property is available for $250,000 and the investor estimates that he can borrow $200,000 at 8 percent interest and that the property will require the following total expenditures during the next year. Inspection $ 500 Title Search 1,000 Renovation 13,000 Landscaping 800 Loan interest 12,800 Insurance 1,800 Property taxes 6,000 Selling expenses 8,000 a) The Investor is wondering what such a property must sell for after one year in order to earn a 20 percent return (IRR) on equity. What other issues must he consider? b) The lender now is concerned that if the property does not sell, he may have to carry the property for one additional year. He believes that he could rent it and realize net cash flow before debt service of $1,200 per month. However, he would have to make an additional $12.800 in interest payments on his loan during that time, and then sell. What would the price have to be at the end of year 2 in order to earn a 20 percent IRR on equity? Expectations: al Calculate the price at which you will make a 20% return on your equity selling one year later Explain step by step and the log of each step in your calculation List in the spread theet the cashflowi mooth by month and the calculation of the IRA that results in a 20% return on your equity b) repeat the what you did in part) for two years incorporating the new information about year 2 trental income for example) List in the spreadsheet the cathows month by month and the calculation of the IRR that results in 20% return on your equity