Question: Ba. Use your proforma for FSG Gardens and create a sensitivity table examining the IRR. We want to know the impact of changes to Annual

Ba. Use your proforma for FSG Gardens and create a sensitivity table examining the IRR. We want to know the impact of changes to Annual Rental Appreciation Rate by 1.5% and changes to maintenance by + $50. Please submit the highlighted squares. Please put your answer in percentage with two decimal places for instance put 7.63 for 7.63% Please put dollar amounts with two decimal places as well. Please enter a positive value. All questions should be completed in excel. Rounding will result in an incorrect answer. IRR Annual Rental Appreciation Rate 1.50% 2.00% 2.50% 7.73% 200 (a) Maintenance 250 300 (b) What is the value in cell(a)? Bb. Use your proforma for FSG Gardens and create a sensitivity table examining the IRR. We want to know the impact of changes to Annual Rental Appreciation Rate by 1.5% and changes to maintenance by + $50. Please submit the highlighted squares. Please put your answer in percentage with two decimal places for instance put 7.63 for 7.63% Please put dollar amounts with two decimal places as well. Please enter a positive value. All questions should be completed in excel. Rounding will result in an incorrect answer. IRA 7.73% Annual Rental Appreciation Rate 1.50% 2.00% 2.50% ca) Maintenance 200 250 300 (b) Ba. Use your proforma for FSG Gardens and create a sensitivity table examining the IRR. We want to know the impact of changes to Annual Rental Appreciation Rate by 1.5% and changes to maintenance by + $50. Please submit the highlighted squares. Please put your answer in percentage with two decimal places for instance put 7.63 for 7.63% Please put dollar amounts with two decimal places as well. Please enter a positive value. All questions should be completed in excel. Rounding will result in an incorrect answer. IRR Annual Rental Appreciation Rate 1.50% 2.00% 2.50% 7.73% 200 (a) Maintenance 250 300 (b) What is the value in cell(a)? Bb. Use your proforma for FSG Gardens and create a sensitivity table examining the IRR. We want to know the impact of changes to Annual Rental Appreciation Rate by 1.5% and changes to maintenance by + $50. Please submit the highlighted squares. Please put your answer in percentage with two decimal places for instance put 7.63 for 7.63% Please put dollar amounts with two decimal places as well. Please enter a positive value. All questions should be completed in excel. Rounding will result in an incorrect answer. IRA 7.73% Annual Rental Appreciation Rate 1.50% 2.00% 2.50% ca) Maintenance 200 250 300 (b)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
