Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I need the excel spreadsheet for Frank Smith's plumbing. Frank Smith Plumbing Data Needed for analysis: Year-1 Year-2 Year-3 Project Cost of Capital (borrowing) 12.00%
I need the excel spreadsheet for Frank Smith's plumbing.
Frank Smith Plumbing Data Needed for analysis: Year-1 Year-2 Year-3 Project Cost of Capital (borrowing) 12.00% Cost of Truck $200,000 Cost of additional equiment attached to truck $15,000 Tax rate 35% Annual Before Tax & Depreciation Truck Projected Earnings Year-4 Year-5 Year-6 Year-7 Year-8 $60,000 $55,000 $50,000 $40,000 $30,000 Depreciation Percentage Rate (MACRS)* 20.0% 32.0% 19.2% 11.5% 11.5% 5.8% * The proposed truck has an estimated economic life of seven years but will be treated as a five-year MACRS property for depreciation purposes. 0.0% 0.0% $70,000 $70,000 $65,000 Calculate the following -- light yellow highlighted cells need to be completed Year-0 Annual Before Tax & Depreciation Truck Projected Earnings Depreciation Expense Annual Before Tax Truck Projected Earnings Tax Annual Projected Truck Earnings Year-1 Year-2 Year-3 Year-4 Year-5 Year-6 Year-7 Year-8 $31,500.00 24,500.00 $17,550 $29,770.00 22,750.00 $15,418 19,000.00 21,000.00 $22,929 19,250.00 $29,600.00 17,500.00 $26,000.00 24,500.00 Depreciation to add back 6,900.00 Projected Truck Net Cash Flow Decision Criteria: Pay Back Period Discounted Pay Back Period (DPB)** Net Present Value Internal Rate of Return Profitability Index Years 7.03 Years -26857.25 Discounted Cash Flow Needed for DPB Calc. RecommendationsStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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