The world’s Largest Sharp Brain Virtual Experts Marketplace Just a click Away
Levels Tought:
Elementary,Middle School,High School,College,University,PHD
| Teaching Since: | Apr 2017 |
| Last Sign in: | 103 Weeks Ago, 3 Days Ago |
| Questions Answered: | 4870 |
| Tutorials Posted: | 4863 |
MBA IT, Mater in Science and Technology
Devry
Jul-1996 - Jul-2000
Professor
Devry University
Mar-2010 - Oct-2016
In cell b10 calculate the future value of the property in 10 years based on the assessed value, the inflation rate, and the year hold values. Express your answer in positive cash flow.
In the Depreciation worksheet, enter the initial investment value of the condo that Gary wants to purchase by inserting a reference to cell B5 in the Real Estate Data worksheet. Set the savage value of the condo to 160000 after 10 years.
in rental income worksheet, project the income and expense associated with owning the condo. In cell b6, enter the year 1 rental income as equal to 1/12 of the assessed value of the condo from the real estate data worksheet.Â
Please explain all the steps very clearly.
Â
Â
Mountain View CondosAuthorDatePurposeTo calculate the net present value and internal rateof return from a condo investment
-----------