use current market values to fill in the table. , also alternative property purchased price at 485,000 usd in Florida. Case study is Retirement Income: The Case of Direct Investment in Short-Term Rental Property Compared to a Dividend Stock Author: Chia-Li Chien, Stefan W. Cosentino, Hossein Salehi.

Stock Performance
		Year
Stock Cost Basis		2000
Current Stock Price		2023
Number of shares
Long Term Gain	$0.00	=B4-B3
Taxes on Gains	$0.00	=B7*-Exp_TaxRate
Net Sales	$0.00	=B4+B8
Sell # Shares
Net Sales Total	$0.00	=B9*B10
Simple Return	#DIV/0!	=(B4-B3)/B3
Annual Return	#DIV/0!	=(B13+1)^(1/(C4-B13)-1)
Projected Return	Projected Return	Standard Deviation	Allocation
Cash & Cash Alternatives (tax-free)
Long-Term Bonds (Tax-Free)
Large Cap Value Stocks

	Scenario A	Scenario B	Scenario C
Purchase Condo?	Yes	Yes	No
Funding 1) Inherited Cash
Funding 2) Financing
Funding 3) PEP Stock
Net Present Value or NPV
IRR
MIRR			0.00%
EVA=MIRR - Rate_RR
Discounted Payback Period
Net income (Year 1)			$ -
Monthly Expected Income			$ -

Complete the "Stock" tab of your Excel spreadsheet

• Use current market data for this tab, reference your work

Complete "Scenarios" tab on your Excel spreadsheet

• Evaluate scenarios
• Develop rationale and recommendations from the three scenarios stated in the case study, reference your work
• You are encouraged to suggest/add other possible scenarios.
• There is no correct or incorrect recommendation.

Presentation of Recommendations

• Summarize your findings from all Phases (including a recap of property, and scenarios)
• What is your final recommendation? Why?
• What did you learn in this process?
• Would you have done anything differently?