Saved

Complete the following analysis. Do not hard code values in your calculations.

Sales

Variable costs

Fixed costs

Depreciation

EBT

Taxes

Net Income

Sheet$1$

Prev

$28$ of $40$

Next

Exam $($i

Calculating aftertax salvage value $-$ Excel

Sign In

HOME

INSERT

PAGE LAYOUT

FORMULAS

DATA

REVIEW

VIEW

$?$

$[$

Calibri

$11$

$A^{**}{A}^{**}$

$\%$

$$

$7$

B I

U

$$

A$.$

Alignment

Number

Conditional Format as

Cell

Formatting $*$ Table $*$ Styles $*$

Cells

Editing

$\sqrt[\phantom{2}]{2}$

Font

Styles

B

C

D

E

F

G

H

I

J

Consider an asset that costs $$730,000$ and is depreciated straight$-$line to zero over its eight$-$year tax life. The asset is to be used in a five$-$year project; at the end of the project, the asset can be sold for $$192,000.$ If the relevant tax rate is $23$ percent, what is the aftertax cash flow from the sale of this asset?

$\backslash$table$[[$Costs$,$$$,730,000],[$Pretax salvage value,$$,192,000],[$Tax rate,$23\%,],[$Years for depreciation,,$8],[$Year asset is sold,,$5]]$

Complete the following analysis. Do not hard code values in your calculations.

Annual depreciation

Accumulated depreciation

Book value

Sheet$1$

$$

$100\%$