Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Based on NINV, WACC, and CF's results (provided on worksheet), perform a financial feasibility analysis with four capital budgeting methods. NOTE: a rate of 10%
Based on NINV, WACC, and CF's results (provided on worksheet), perform a financial feasibility analysis with four capital budgeting methods. NOTE: a rate of 10% for NPV will be used.
Hotel DelRay New Property Management System (PMS) Acquisition & Installation Project Financial Feasibility Analysis After-tax CFS Years 0 Cumulative CFS 0 1 2 3 4 WACC 0.00% Project's Payback Period The Net Present value (NPV) Project Profitability Index (PI) The Internal Rate of Return (IRR) Hotel DelRay New Property Management System (PMS) Acquisition & Installation Project Estimation of the flow of Funds (Stream of Expected After-Tex CFs) Year 2 Year 3 Year 4 $70,000 $80,000 4-year Financial Projections and After-tax Pro-Forma CF Structure Year 1 Sales Projections $50,000 S60,000 Overhead Costs: Additional Staffing and Dellivery Cost ($10,000 $17,500 ($19 po $20.500) Shipping, Installation, and Insurance Cost $4,000) ($5,500 $7,000) $8,500) Maintenance Cost ($2,000 $3,500) ($5,00) 66,500) Design, Build, and Implementation of the New Technology ($3,000) $4,500) 66,000) 67,500) New Equipment Cost $57,000) NA N/A Less: Depreciation ($1.6) ($1,000 $1,000) $1,600) Total Overhead Cost($83,000) $32,000 $32,000) $14,000 After-tax Salvage Value $9,200 N/A * Before-tax Cash Flows ($33,000) $28,000 $32,000 $36,000 Tax at 40.00% $13200 11200 ($12800) $14,400) Add: Depreciation $1,000 $1,000 $1,000 $1,000 After-tax Cash Flows $17,800 $20,200 $22,600 N/A N/A N/A ($518,800) NINV = $72,800 WACC = 8.29% 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