Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Calculate the stream of CFs for this upgrade project. Required information: -Due to new technology investment, sales are expected to increase on an incremental basis
Calculate the stream of CFs for this upgrade project. Required information:
-Due to new technology investment, sales are expected to increase on an incremental basis of $10,000 increase every year for the next 4 years.
-All overhead costs (except for the new equipment cost) are estimated on an incremental basis of $1,500 increase every year for the next 4 years.
-Tax rate = 40.00%
-Depreciation of the new technology is estimated on a straight-line method, which is set at $1,000 for the next 4 years.
-Estimated cash flows (CFs) are measured on an after-tax basis.
Please provide step by step calculation
Estimation of the Flow of Funds (Stream of Expected After-Tax CFs): The new PMS technology investment is expected to provide higher sales projections for Hotel DelRay, Based on the project's aforementioned assumptions and limitations, DelRay's management team has come up with 4-year financial projections and after-tax pro-forma CF structure including project cost, other charges, tax, and depreciation, which are highlighted in the table below: 4-year Financial Projections and After-Tax Pro-Forma CF structure. Year 1 Year 2 Sales Projections: $50,000 Year 3 Year 4 Overhead Costs: Staffing Cost ($16,000) Shipping, Installation, and Insurance Cost ($4,000) Maintenance Cost ($2,000) Design, Build, and Implementation of the New Technology ($3,000) New Equipment Cost (557,000) Less: Depreciation Total Overhead Cost (S) N/A N/A N/A ($) (S) After-tax Salvage Value S N/A N/A N/A Before-Tax Cash Flows (S) (S) Tax at 40.00% S $ Add: Depreciation $ S S $ After-Tax Cash Flows (S) S New Property Management System (PMS) Acquisition & Installation Project Estimation of the Flow of Funds (Stream of Expected After-Tax CFS) 4-year Financial Projections and After-tax Pro-Forma CF Structure Year 1 Year 2 Sales Projections Year 3 Year 4 Overhead Costs: Additional Staffing and Dellivery Cost Shipping, Installation, and Insurance Cost Maintenance Cost Design, Build, and Implementation of the New Technology New Equipment Cost N/A N/A NIA Less: Depreciation Total Overhead Cost After-tax Salvage Value N/A N/A N/A Before-tax Cash Flows Tax at 40.00% Add: Depreciation After-tax Cash Flows 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