Answered step by step
Verified Expert Solution
Link Copied!

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.
image text in transcribed
image text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Introduction To Derivatives And Risk Management

Authors: Robert Brooks, Don M Chance, Roberts Brooks

8th Edition

0324601212, 9780324601213

More Books

Students also viewed these Finance questions

Question

Why is succession planning important?

Answered: 1 week ago

Question

When did the situation become unable to be resolved? Why?

Answered: 1 week ago