$20,000 2.00% 6 2. Apply capital budgeting to property investment 7 (a) Develop proforma cash flows for property investment project 8 (6) Compute NPV, IRR 9 (c) Develop Problem Solving and Critical Thinking Skills 10 11 1) buy house in all Cash Or Mortgage; project period = 15 years 2 2) property value 13 3) down payment 74 4) 10-yr mortgage at 3.5% 15 16 case 1: Investment 17 18 NPV= 19 (NO inflation, rental, property value appreciation) XXXXX $200,000 $50,000 ($18,036) 5) Rent-to-Price Ratio 10% 6) inflation, rental, property value appreciation 7) sell the property at the end of 15th year 8) annual rental income IRR= CFO CF1 CF2 CF3 CF4 CF5 CF6 CF7 CF8 CF9 CF10 CF11 CF12 CF13 CF14 CF15 Xxxxx 20 XXXXX XXXXX XXXXX XXXXX XXXXX -50,000 -200,000 1,964 20,000 1,964 20,000 1,964 20,000 1,964 20,000 1,964 20,000 XXXXX 20,000 20,000 20,000 20,000 20,000 XXXXX XXXXX 20,000 220,000 21 XXXXX 20,000 20,000 20,000 20,000 20,000 22 23 Q#1 Use IRR to comapare Cash vs Mortgage? With all cash buying, all the retum of the property (from rental) is eamed and not eaten away by mortgage cost, hence Cash better than Mortgage? 24 25 26 Q#2 At required retum 5%, find NPV to compare Cash vs Mortgage (mutually exclusive), conclusion consistent with IRR? How about required rate 4%, required rate 3.5%, required rate 3%, etc., discuss your finding. 27 28 29 (WITH inflation, rental, property value appreciation) 30 xoxoxoxo 31 Xxxxx -50,000 1,964 2,364 2,772 XXXXX -200,000 20,000 20,400 20,808 21,224 *growing rental=> 20,000 20,400 20,808 21,224 XXXXX 21,649 21,649 XXXXX XXXXX XXXXX XXXXX XXXXX 24,380 24,867 25,365 XXXXX XXXXX 22,082 22,523 22,974 23,433 23,902 24,380 24,867 25,365 25,872 295,563 22,082 22,523 22,974 23,433 23,902 24,380 24,867 25,365 25,872 26,390 32 33 34 Q#3 Now assume rental grows with inflation, does your conclusion change? Use your numbers to find support for "Rental is a hedge against inflation". 35 36 case 2: Ownership 37 38 (18,036) 0 0 0 -50,000 -200,000 (18,036) (18,036) 0 0 (18,036) 0 (18,036) (18,036) 0 0 (18,036) 0 (18,036) (18,036) 0 0 (18,036) 0 0 200,000 0 200,000 xxxxx 0 0 0 0 O 39 10 #1 Q#4 42 Q#5 You buy the house just for self-use. What's your conclusion now based on IRR, explain. Now go back to case 1, think about areas with lower Rent-to-Price Ratio, such as San Fransisco, NYC. Try 5%, 3.5% and a even lower Rent-to-Price ratio, discuss your findings. Discuss/digest/summarize your If-Then findings so far. Summarize any additional insights you may have figured from this exercise (e.g., at a different inflation rate, you play with the Excel). 43 44 Q.#6 25 Q#7 (optional) Ti 2. Apply capital budgeting to property investment (a) Develop proforma cash flows for property investment project (b) Compute NPV, IRR (c) Develop Problem Solving and Critical Thinking Skills 1) buy house in all Cash Or Mortgage; project period = 15 years 2) property value 3) down payment 4) 10-yr mortgage at 3.5% $20,000 2.00% $200,000 $50,000 ($18,036) 5) Rent-to-Price Ratio 10% 6) inflation, rental, property value appreciation 7) sell the property at the end of 15th year 8) annual rental income CFO CF1 CF2 CF3 CF4 CF5 CF6 CF7 CF8 CF9 CF10 CF11 CF12 CF13 CF14 CF15 -50,000 -200,000 1,964 1,964 20,000 20,000 1,964 20,000 1,964 20,000 1,964 20,000 XXXXX 20,000 XXXXX 20,000 XXXXX 20,000 XXXXX 20,000 XXXXX 20,000 20,000 XXXXX XXXXX XXXXX XXXXX 20,000 20,000 20,000 20,000 20,000 220,000 -50,000 1,964 2,364 2,772 -200,000 20,000 20,400 20,808 *growing rental=> 20,000 20,400 20,808 XXXXX XXXXX XXXXX XXXXX XXXXX XXXXX XXXXX 24,380 24,867 25,365 XXXXX XXXXX 21,224 21,649 22,082 22,523 22,974 23,433 23,902 24,380 24,867 25,365 25,872 295,563 21,224 21,649 22,082 22,523 22,974 23,433 23,902 24,380 24,867 25,365 25,872 26,390 0 0 -50,000 (18,036) (18,036) -200,000 0 0 (18,036) 0 (18,036) (18,036) (18,036) (18,036) (18,036) (18,036) (18,036) 0 0 0 0 0 0 0 0 0 0 0 200,000 0 200,000 0 0 XXXXX Q#1 Use IRR to comapare Cash vs Mortgage? With all cash buying, all the return of the property (from rental) is earned and not eaten away by mortgage cost, hence Cash better than Mortgage? Q#2 At required return 5%, find NPV to compare Cash vs Mortgage (mutually exclusive), conclusion consistent with IRR? How about required rate 4%, required rate 3.5%, required rate 3%, etc., discuss your finding. (WITH inflation, rental, property value appreciation) Xxxxx XXXXX Q#3 Now assume rental grows with inflation, does your conclusion change? Use your numbers to find support for "Rental is a hedge against inflation". case 2: Ownership xxxxx XXXXX Q#4 You buy the house just for self-use. What's your conclusion now based on IRR, explain. C#5 Now go back to case 1, think about areas with lower Rent-to-Price Ratio, such as San Fransisco, NYC. Try 5%, 3.5% and a even lower Rent-to-Price ratio, discuss your findings. Q#6 Discuss/digest/summarize your If-Then findings so far. Q#7 (optional) Summarize any additional insights you may have figured from this exercise (e.g., at a different inflation rate, you play with the Excel). $20,000 2.00% 6 2. Apply capital budgeting to property investment 7 (a) Develop proforma cash flows for property investment project 8 (6) Compute NPV, IRR 9 (c) Develop Problem Solving and Critical Thinking Skills 10 11 1) buy house in all Cash Or Mortgage; project period = 15 years 2 2) property value 13 3) down payment 74 4) 10-yr mortgage at 3.5% 15 16 case 1: Investment 17 18 NPV= 19 (NO inflation, rental, property value appreciation) XXXXX $200,000 $50,000 ($18,036) 5) Rent-to-Price Ratio 10% 6) inflation, rental, property value appreciation 7) sell the property at the end of 15th year 8) annual rental income IRR= CFO CF1 CF2 CF3 CF4 CF5 CF6 CF7 CF8 CF9 CF10 CF11 CF12 CF13 CF14 CF15 Xxxxx 20 XXXXX XXXXX XXXXX XXXXX XXXXX -50,000 -200,000 1,964 20,000 1,964 20,000 1,964 20,000 1,964 20,000 1,964 20,000 XXXXX 20,000 20,000 20,000 20,000 20,000 XXXXX XXXXX 20,000 220,000 21 XXXXX 20,000 20,000 20,000 20,000 20,000 22 23 Q#1 Use IRR to comapare Cash vs Mortgage? With all cash buying, all the retum of the property (from rental) is eamed and not eaten away by mortgage cost, hence Cash better than Mortgage? 24 25 26 Q#2 At required retum 5%, find NPV to compare Cash vs Mortgage (mutually exclusive), conclusion consistent with IRR? How about required rate 4%, required rate 3.5%, required rate 3%, etc., discuss your finding. 27 28 29 (WITH inflation, rental, property value appreciation) 30 xoxoxoxo 31 Xxxxx -50,000 1,964 2,364 2,772 XXXXX -200,000 20,000 20,400 20,808 21,224 *growing rental=> 20,000 20,400 20,808 21,224 XXXXX 21,649 21,649 XXXXX XXXXX XXXXX XXXXX XXXXX 24,380 24,867 25,365 XXXXX XXXXX 22,082 22,523 22,974 23,433 23,902 24,380 24,867 25,365 25,872 295,563 22,082 22,523 22,974 23,433 23,902 24,380 24,867 25,365 25,872 26,390 32 33 34 Q#3 Now assume rental grows with inflation, does your conclusion change? Use your numbers to find support for "Rental is a hedge against inflation". 35 36 case 2: Ownership 37 38 (18,036) 0 0 0 -50,000 -200,000 (18,036) (18,036) 0 0 (18,036) 0 (18,036) (18,036) 0 0 (18,036) 0 (18,036) (18,036) 0 0 (18,036) 0 0 200,000 0 200,000 xxxxx 0 0 0 0 O 39 10 #1 Q#4 42 Q#5 You buy the house just for self-use. What's your conclusion now based on IRR, explain. Now go back to case 1, think about areas with lower Rent-to-Price Ratio, such as San Fransisco, NYC. Try 5%, 3.5% and a even lower Rent-to-Price ratio, discuss your findings. Discuss/digest/summarize your If-Then findings so far. Summarize any additional insights you may have figured from this exercise (e.g., at a different inflation rate, you play with the Excel). 43 44 Q.#6 25 Q#7 (optional) Ti 2. Apply capital budgeting to property investment (a) Develop proforma cash flows for property investment project (b) Compute NPV, IRR (c) Develop Problem Solving and Critical Thinking Skills 1) buy house in all Cash Or Mortgage; project period = 15 years 2) property value 3) down payment 4) 10-yr mortgage at 3.5% $20,000 2.00% $200,000 $50,000 ($18,036) 5) Rent-to-Price Ratio 10% 6) inflation, rental, property value appreciation 7) sell the property at the end of 15th year 8) annual rental income CFO CF1 CF2 CF3 CF4 CF5 CF6 CF7 CF8 CF9 CF10 CF11 CF12 CF13 CF14 CF15 -50,000 -200,000 1,964 1,964 20,000 20,000 1,964 20,000 1,964 20,000 1,964 20,000 XXXXX 20,000 XXXXX 20,000 XXXXX 20,000 XXXXX 20,000 XXXXX 20,000 20,000 XXXXX XXXXX XXXXX XXXXX 20,000 20,000 20,000 20,000 20,000 220,000 -50,000 1,964 2,364 2,772 -200,000 20,000 20,400 20,808 *growing rental=> 20,000 20,400 20,808 XXXXX XXXXX XXXXX XXXXX XXXXX XXXXX XXXXX 24,380 24,867 25,365 XXXXX XXXXX 21,224 21,649 22,082 22,523 22,974 23,433 23,902 24,380 24,867 25,365 25,872 295,563 21,224 21,649 22,082 22,523 22,974 23,433 23,902 24,380 24,867 25,365 25,872 26,390 0 0 -50,000 (18,036) (18,036) -200,000 0 0 (18,036) 0 (18,036) (18,036) (18,036) (18,036) (18,036) (18,036) (18,036) 0 0 0 0 0 0 0 0 0 0 0 200,000 0 200,000 0 0 XXXXX Q#1 Use IRR to comapare Cash vs Mortgage? With all cash buying, all the return of the property (from rental) is earned and not eaten away by mortgage cost, hence Cash better than Mortgage? Q#2 At required return 5%, find NPV to compare Cash vs Mortgage (mutually exclusive), conclusion consistent with IRR? How about required rate 4%, required rate 3.5%, required rate 3%, etc., discuss your finding. (WITH inflation, rental, property value appreciation) Xxxxx XXXXX Q#3 Now assume rental grows with inflation, does your conclusion change? Use your numbers to find support for "Rental is a hedge against inflation". case 2: Ownership xxxxx XXXXX Q#4 You buy the house just for self-use. What's your conclusion now based on IRR, explain. C#5 Now go back to case 1, think about areas with lower Rent-to-Price Ratio, such as San Fransisco, NYC. Try 5%, 3.5% and a even lower Rent-to-Price ratio, discuss your findings. Q#6 Discuss/digest/summarize your If-Then findings so far. Q#7 (optional) Summarize any additional insights you may have figured from this exercise (e.g., at a different inflation rate, you play with the Excel)