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
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
...
Review
Review
24/7 Homework Help
Stuck on a homework question? Our verified tutors can answer all questions, from basic math to advanced rocket science!
Similar Content
Related Tags
Little Fires Everywhere
by Celeste Ng
The Road
by Cormac McCarthy
The Rhythm Section
by Mark Burnell
Nervous Conditions
by Tsitsi Dangarembga
The Awakening
by Kate Chopin
The English Patient
by Michael Ondaatje
Dr Jekyll And Mr Hyde
by Robert Louis Stevenson
The Red Badge of Courage
by Stephen Crane
Things That Matter
by Charles Krauthammer