Frank Smith Plumbing essay, business and finance homework help

User Generated

eebovaf3

Business Finance

Description

I just need to calculations part for this assignment, not the actual essay part.

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


User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Dear here is the complete work. Thank you and bye.

Frank
Smith
Plumbing
Details
MACRS
rate

Year 0

Year 1
20.00%

Investmen
t in Truck (215,000)
Annual
projected
earninf
before tax
&
depreciati
on
70,000
Depreciati
on
(43,000)
Annual
Before
Tax
Income
27,000
Tax
@35%
9,450
Post Tax
projected
Earning
17,550
Add Back
Depreciati
on
43,000
Net Cash
flow
60,550
PV factor
@ 12%
1
0.893
PV of
Cash
flows
(215,000) 54,063
Pay Back
Period in
years=
3.59
...


Anonymous
Excellent resource! Really helped me get the gist of things.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags