Prepare a cash flow statement , Finance Basics

Assignment Help:

Q1.  A local delivery company has purchased a delivery truck for $15,000.  The truck will be depreciated under MACRS as a five year property.  The trucks market value (salvage value) is expected to decrease by $2,500 per year.  It is expected that the purchase of the truck will increase revenue by $10,000 annually.  The operations and maintenance cost are expected to be $3,000 per year.  The firm is in a 40% tax bracket and its MARR is 15%. The company plans to keep the truck for only two years.   The Income statement is shown below and attached.  

a.  Prepare a cash flow statement for this proposal.

b.  Determine the equivalent present worth  and the internal rate of return.

c.  Should the project be approved?

 

Purchase Cost

($15,000)

year 1

year 2

 

Depreciation MACRS

5

20%

32%

 

Depreciation $

 

$3,000

$2,400

 

Book Value

 

$12,000

$9,600

 

Salvage decrease

$2,500

annually

 

 

Salvage Value

 

$12,500

$10,000

 

Gain

 

 

$400

 

Revenue Increase

$10,000

annually

 

 

O & M costs

($3,000)

annually

 

 

Taxes

40%

 

 

 

MARR

15%

 

 

 

Time span

2

years

 

 

 

 

 

 

Income Statement

0

1

2

Revenue

 

$10,000

$10,000

Direct Costs

 

 

 

 

Labor

 

 

 

 

Material

 

 

 

 

Overhead

 

 

 

 

Cost of Goods Sold (COGS)

 

($3,000)

($3,000)

 

Gross Margin

 

$7,000

$7,000

 

Depreciation

 

($3,000)

($2,400)

Earnings Before Interest and Taxes (EBIT)

$11,000

$11,600

 

Income Tax

 

($4,400)

($4,640)

 

Net Income

 

$6,600

$6,960


Related Discussions:- Prepare a cash flow statement

Example of asset based valuation, Example of Asset Based Valuation Ext...

Example of Asset Based Valuation Extracted information from the books of Kent Limited.   Current liabilities Bank overdraft    Sh. 300,000

Limitations of ratio, Limitations of Ratio Ratios have weaknesses as f...

Limitations of Ratio Ratios have weaknesses as following like: 1. They avoid the size of the firm being compared as in cross-sectional analysis; the firm being compared m

Dividend yield or gordon''s model, Dividend yield or Gordon's Model Th...

Dividend yield or Gordon's Model This model is used to determine the cost of various capital components in particular: Cost of equity - K e Cost of preferenc

Marginal cost and marginal revenue, Use the concepts of marginal cost and m...

Use the concepts of marginal cost and marginal revenue to derive an optimal capital budget for Company X, which has identified 7 possible investment projects and determined its cos

Agency theory - finance, Agency Theory The agency problem between mana...

Agency Theory The agency problem between managers and shareholders can be resolved via paying high dividends. If retention is low, managers are necessary to increase additiona

calculate the growth rate, The Mountain Fresh Company had earnings per sha...

The Mountain Fresh Company had earnings per share (EPS) of $6.32 in 2006 and $11.48 in 2011. The company pays out 30 percent of its earnings as dividends per share (DPS), and the

Working capital cycle, Working Capital Cycle The Concept of Working C...

Working Capital Cycle The Concept of Working Capital/Cash Operating Cycle Working capital cycle refers to period such elapses between the payment for raw materials bought

Liquidity ratios - ratio analysis, Liquidity Ratios - Ratio Analysis I...

Liquidity Ratios - Ratio Analysis It also identified as working capital ratios.  They show capability of the firm to meet its short term maturing financial obligation/recent l

Risk-return trade-off, Risk-Return Trade-Off Most financial decisions ...

Risk-Return Trade-Off Most financial decisions comprise alternative courses of action. The choices have different returns and risk.  As like example, must we buy a replacement

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd