Submit Assignment ourses/1448480/assignments/9005195?module_item_id=18541021 5 Assignment - Sensitivity Analysis in Capital Bud- ting Analysis Submitting a file upload Points 7 ue Sunday by 11:59pm ASSIGNMENT Sensitivity Analysis in Capital Budgeting Analysis Use Sheet "4" for this assignment. In the townhome investment model, do a sensitivity analysis by using a two-input data table. The two input variables are Rent and Resell Value: 0- Rent ($16.000, $18,000..... $30,000) Resell value ($250,000, $280,000,..., $550,000) Show IRR as a function of these two variables. Use conditional formatting to highlight the unprofitable combinations. M3 Assignment - Sensitivity Analysis in Capital Budgeting Analysis Rubric Construct input variables 1 pt Use the correct result cell 1 pt Complete the data table 3 pts Highlight correct cells using conditional formatting 2 pt Total 7 pts Ne Previous MecBook Pro Dll 9 20 8 7 8 > % 5 6 $ 4 # 3 I U 2 Y 1 T R E K W J H G F D S A 3 N B V C N command option Submit Assignment ourses/1448480/assignments/9005195?module_item_id=18541021 5 Assignment - Sensitivity Analysis in Capital Bud- ting Analysis Submitting a file upload Points 7 ue Sunday by 11:59pm ASSIGNMENT Sensitivity Analysis in Capital Budgeting Analysis Use Sheet "4" for this assignment. In the townhome investment model, do a sensitivity analysis by using a two-input data table. The two input variables are Rent and Resell Value: 0- Rent ($16.000, $18,000..... $30,000) Resell value ($250,000, $280,000,..., $550,000) Show IRR as a function of these two variables. Use conditional formatting to highlight the unprofitable combinations. M3 Assignment - Sensitivity Analysis in Capital Budgeting Analysis Rubric Construct input variables 1 pt Use the correct result cell 1 pt Complete the data table 3 pts Highlight correct cells using conditional formatting 2 pt Total 7 pts Ne Previous MecBook Pro Dll 9 20 8 7 8 > % 5 6 $ 4 # 3 I U 2 Y 1 T R E K W J H G F D S A 3 N B V C N command option