Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Analyze the case study, Frank Smith Plumbing. Analyze the Frank Smith Plumbing's Financial Statement spreadsheet. Compare the cost of the truck to the cash flow

image text in transcribed

Analyze the case study, "Frank Smith Plumbing."

Analyze the "Frank Smith Plumbing's Financial Statement" spreadsheet.

Compare the cost of the truck to the cash flow records

Compile your calculations in a Microsoft Excel document

Develop a 1,050-word analysis and include the following:

  • Explain why limited leverage is good for business. Show the profitability of the project so that Stephanie can convince her father to purchase the truck by borrowing money.
  • Explain how Stephanie should convince her mother that it is inappropriate to call the bank manager and his wife for assistance in getting the loan approval?
  • Analyze whether the investment in the truck is profitable.
  • Explain whether it is more beneficial for Frank to close his business.
  • Explainwhat you would do in this same situation.

Format your assignment consistent with APA guidelines.

image text in transcribed Frank Smith Plumbing Data Needed for analysis: Year-1 Year-2 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 $70,000 $70,000 Depreciation Percentage Rate (MACRS)* 20.0% 32.0% * The proposed truck has an estimated economic life of seven years but will be treated as a five-year MACRS property Calculate the following -- light yellow highlighted cells need to be co Year-0 Year-1 Year-2 Annual Before Tax & Depreciation Truck Projected Earnings Depreciation Expense Annual Before Tax Truck Projected Earnings Tax Annual Projected Truck Earnings Depreciation to add back 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 Years Discounted Cash Flow Needed for DPB Calc. Recommendations: mith Plumbing ded for analysis: Year-3 Year-4 Year-5 Year-6 Year-7 Year-8 $65,000 $60,000 $55,000 $50,000 $40,000 $30,000 19.2% 11.5% 11.5% 5.8% ed as a five-year MACRS property for depreciation purposes. 0.0% 0.0% Year-7 Year-8 ow highlighted cells need to be completed sion Criteria: mmendations: Year-3 Year-4 Year-5 Year-6

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

Fundamentals of Financial Management

Authors: Eugene F. Brigham

Concise 9th Edition

1305635937, 1305635930, 978-1305635937

More Books

Students also viewed these Finance questions