Answered step by step
Verified Expert Solution
Question
1 Approved Answer
This is my answer, please check it. If wrong, please use excel and show formulas. price $200,000.00 outflows $(238,300.00) =-SUM(B1,B4:B11) amount borrowed $160,000.00 required sell
This is my answer, please check it. If wrong, please use excel and show formulas.
price | $200,000.00 | outflows | $(238,300.00) | =-SUM(B1,B4:B11) | |
amount borrowed | $160,000.00 | required sell price is: | $(285,960.00) | =E1*(1+B12) | |
interest | 4.50% | ||||
inspection | $ 500.00 | ||||
title search | $ 1,000.00 | cash inflow | 14400 | =B13*12 | |
renovation | $ 13,000.00 | outflows | $(231,100.00) | =E1-B14+E5 | |
landscaping | $ 800.00 | required sell price is: | $(277,320.00) | =E6*(1+B12) | |
loan interest | $ 7,200.00 | ||||
insurance | $ 1,800.00 | ||||
property taxes | $ 6,000.00 | ||||
selling expenses | $ 8,000.00 | ||||
IRR | 20% | ||||
cash flow | 1200 | ||||
additional interest | 7200 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started