Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

dont know what cell b45 is... formula is (sp-bv) * tax rate. problem is i dont know how to find bv. sp= 62,500 and tax

dont know what cell b45 is... formula is (sp-bv) * tax rate. problem is i dont know how to find bv. sp= 62,500 and tax rate = .200... help me find bv for cell b45 please
image text in transcribed
image text in transcribed
\begin{tabular}{rcccccc|} YEAR & 1 & 2 & 3 & 4 & 5 \\ $ & (87,500.00)$ & (156,250.00)$(106,250.00)$ & (81,250.00)$ & (56,250.00) \\ $ & 190,000.00$ & 120,000.00$110,000.00$ & 60,000.00$ & \\ \hline & (277,500.00)$ & (276,250.00)$(216,250.00)$ & (141,250.00)$ & (56,250.00) \end{tabular} - Earnings belore Tawes \& Depreciation less Change in Depreciation Change in CF belore Taxes less Taxes@ 20%. Change in CF after Taves plus Depreclation Change in After-tax Cash Flow + Terminal Year CF (in Year 5) \begin{tabular}{|cccccc|} \hline 1 & 2 & 3 & 4 & 5 \\ \hline 130,000 & 130,000 & 130,000 & 130,000 & 130,000 \\ \hline277,500 & 276,250 & 216,250 & 141,250 & 56,250 \\ \hline 407,500 & 406,250 & 346,250 & 271,250 & 186,250 \\ 881,500 & 81,250 & 69,250 & 54,250 & 37,250 \\ \hline 326,000 & 325,000 & 277,000 & 217,000 & 149,000 \\ 48,500 & 48,750 & 60,750 & 75,750 & 92,750 \\ \hline 374,500 & 373,750 & 337,750 & 292,750 & 241,750 \\ 0 & 0 & 0 & 0 & \\ \hline \end{tabular} Per Year After-tax Cash flow Sale New Flaxot 62,500 45 Less tax an 5 ale =(5PDV)4 tax rate 46 Lost 5 ale of Oid FlaXer- 47 less tax on Sale 48 Less Change in NWC Terminal Non-operating Cash Flow

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

Forensic Accounting And Fraud Examination

Authors: Mary Jo Kranacher, Richard Riley

2nd Edition

1119494338, 9781119494331

More Books

Students also viewed these Accounting questions

Question

The implicit equation of x = sin ( t ) and y = 2 cos ( t ) is:

Answered: 1 week ago

Question

using signal flow graph

Answered: 1 week ago