You are just about to graduate for the prestigious Utah Valley University. You opted to trade in your accounting major at the last minute and pursue a finance degree.You are so glad you did. No late nights, minimum wage, and weekend jobs at McDonalds. A wise choice.Your first job will pay well but you decide to stay living in your parents basement and use the rest of your student loan to purchase a home and rent it out as the first investment property in what certainly will be arobust real estate empire in the future which you have called, Slum Lords Associated. After working with a mortgage broker, you believe you can get a mortgage for $350,000, the full value of the house, at 3.5%, for thirty years. You believe the home can be rented for$3,050 per monthand that rents will increase by 5% every year. Vacancy costs will off setrental revenue by 5% per year. Management costs include maintenance you will be required todo on the property and are expected to be approximately4.5%of the net rental revenue.Your marginal tax rate is25%.You expect the home to be depreciated, on a straight-line basis over the thirty years.You believe you will keep the property for thirty years and then sell it.The terminal value of your property can be calculated using time value of money principles, assuming its value will increase at an average of 6% per year from today(the discount rate), compounded annually. Please also show your solutions with formula in excel, thank you.

Imprortant Date Dispurt Rals Mortgage rare Rama Tax Ral Vacancy Maintenance Expenses Slum Lords Asssociated Arual Estintos 9 1D 11 12 13 14 15 16 17 Innal memant Retal wone - Vacancy Net Rental Revenue - Maragwow Cost - Depreiston Pre-Tax Rental Income - Taxes + Dion fer Tax Operating Cash Flow Terminal Valur Value in Cel AG25) Total Discourfing Cash Flows NPUT NH Hantly forme Annualized Tot Discowling Cash How NPV RR Moril Mariage Part Imprortant Date Dispurt Rals Mortgage rare Rama Tax Ral Vacancy Maintenance Expenses Slum Lords Asssociated Arual Estintos 9 1D 11 12 13 14 15 16 17 Innal memant Retal wone - Vacancy Net Rental Revenue - Maragwow Cost - Depreiston Pre-Tax Rental Income - Taxes + Dion fer Tax Operating Cash Flow Terminal Valur Value in Cel AG25) Total Discourfing Cash Flows NPUT NH Hantly forme Annualized Tot Discowling Cash How NPV RR Moril Mariage Part