Answered step by step
Verified Expert Solution
Link Copied!

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

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

Managerial Accounting

Authors: James Jiambalvo

6th edition

9781119158226, 111915801X, 1119158222, 978-1119158011

More Books

Students also viewed these Finance questions