For Vaiyap

S

heet1

1

Task 2 319.1.3-01-10, 2.1-04, 2.5-05

apital

udgeting Student Template

evised

ay 8, 2011

nitial

ork Cap

xp 1

2,800,000

A

3,600,000

2,700,000 2,500,000

B 3,000,000 200,000 3,000,000 3,200,000 3,400,000 3,800,000 2,400,000 2,400,000

2,800,000

120,000

our Task 2

ata

C

250,000 3,400,000

3,700,000

2,800,000

2,900,000 2,500,000

140,000 2,500,000

1 & 2

D 2,900,000

2,940,000

3,600,000

2,500,000 2,600,000 2,600,000 30% 160,000 2,700,000

3,100,000 3,400,000 3,600,000 3,240,000 E 2,850,000 200,000 3,200,000 3,600,000 3,800,000 3,600,000 2,500,000 2,800,000 3,400,000 2,600,000 25%

2,600,000

2,400,000 2,600,000 2,700,000 2,500,000 F 2,900,000

3,240,000 3,470,000

2,400,000 2,500,000

2,800,000 180,000 3,000,000 3,200,000 3,600,000 3,470,000

2,600,000 2,800,000 2,500,000 32% 160,000 2,570,000

25%

180,000 3,000,000 3,200,000 3,600,000 3,800,000 2,300,000 2,600,000 2,800,000 2,800,000 32% 160,000

140,000 I

3,930,000 3,240,000 3,100,000 3,300,000 3,400,000 2,500,000 30%

2,600,000

220,000

3,100,000 300,000 3,170,000 3,240,000 3,470,000 3,600,000 2,400,000 2,500,000 2,750,000 2,600,000 32% 150,000 2,700,000

200,000 3,200,000 3,600,000 3,800,000 3,700,000 2,500,000 2,800,000 3,400,000 2,850,000 25% 130,000 2,500,000

180,000 2,940,000

3,240,000 3,470,000 2,200,000 2,500,000 2,600,000 2,500,000 30% 160,000 2,800,000

M 3,400,000 220,000 3,100,000 3,400,000 3,600,000 3,800,000 2,400,000 2,600,000 2,700,000 2,700,000 25% 140,000 2,480,000

per Year

N 2,800,000 250,000 3,400,000 3,500,000 3,700,000 3,240,000 2,800,000 2,850,000 2,900,000 2,500,000 22% 140,000 2,600,000

Years 1 & 2 Years 3 & 4 Years 5 & 6 Years 7 & 8

2,900,000 300,000 3,170,000 3,240,000 3,470,000 3,930,000 2,400,000 2,500,000 2,750,000 3,300,000 32% 150,000 2,700,000

2,840,000

3,200,000 3,600,000 3,800,000 3,700,000 2,500,000 2,800,000 3,400,000 2,850,000

130,000 2,500,000

2,850,000 180,000 2,940,000

3,240,000 3,600,000 2,200,000 2,500,000 2,600,000 2,600,000 30% 160,000 2,140,000

R 2,600,000 240,000 3,750,000 3,860,000 3,930,000 3,700,000 3,100,000 3,250,000 3,300,000 2,650,000 30% 190,000 2,140,000

S 2,800,000 260,000 3,750,000 3,860,000 3,930,000 3,470,000 3,100,000 3,000,000 3,400,000 2,500,000 30% 190,000 2,800,000

T 2,840,000 225,000 3,200,000 3,600,000 3,800,000 3,700,000 2,500,000 2,800,000 3,400,000 2,950,000 28% 160,000 2,480,000

2,900,000 250,000 3,400,000 3,500,000 3,700,000 3,800,000 2,800,000 2,850,000 2,900,000 2,800,000 22% 140,000 2,600,000

2,800,000 300,000 3,170,000 3,240,000 3,470,000 3,400,000 2,400,000 2,500,000 2,750,000 2,400,000 32% 150,000 2,580,000

W 2,900,000 200,000 3,000,000 3,200,000 3,400,000 3,400,000 2,400,000 2,400,000 2,650,000 2,400,000 28% 120,000 2,700,000

Y 2,750,000 200,000 3,100,000 3,200,000 3,400,000

2,600,000 2,500,000 2,500,000 2,600,000 28% 120,000 2,580,000

2,750,000 200,000 3,000,000 3,200,000 3,200,000 3,400,000 2,400,000 2,400,000 2,650,000 2,500,000 28% 120,000 2,580,000

Value:

Present

Investment
Cash Flows

Investment
Year 1
Year 2
Year 3
Year 4
Year 5
Year 6
Year 7

Net

Cash Flow Investment
Investment
Year 1

Year 2
Year 3
Year 4

Year 5
Year 6
Year 7
Year 8

Years

F N T C B
R M
Student Name: A Sobala I Investment W Cash 1 Cash 2 Cash 3 Cash 4 E Exp 2 Exp 3 Exp 4 Tax Rate Restoration 2,700,000
X 3,000,000 210,000 3,

200,000 3,600,000 3,800,000 3,700,000 2,500,000 2,800,000 3,200,000 2,900,000 30% 120,000
Enter your first initial and last name in the fields above. 3,

250,000 220,000 3,100,000 3,400,000 3,

240,000 2,400,000 2,600,000 25% 140,000 2,580,000
2,650,000 28% 2,480,000
Y D 2,940,000 3,500,000 3,470,000 2,850,000 22%
Years Years 3 & 4 Years 5 & 6 Years 7 & 8 180,000 3,

160,000 3,240,000 2,200,000
Estimated Cash Receipts from tool sales each year. 130,000
Estimated Cash Expenses for operations each year 300,000 3,170,000 3,930,000 2,750,000 3,300,000 32% 150,000 2,570,000
Initial Investment for equipment, etc. 3,250,000 G 2,300,000
Marginal Tax Rate H 2,820,000 2,140,000
Restoration at the end of 8 years 2,450,000 260,000 3,750,000 3,860,000 190,000
Working Capital required J
K 2,840,000
L 2,950,000 3,260,000
Entrepreneur D
Net Cash Flow
O
Expected annual sales of new product P 225,000 26%
Q 3,160,000
Expected annual costs of new product
Cash expenses
Depreciation expense
Income before taxes U
Income tax at marginal rate V
Net income
Net annual cash flow for years shown 3,360,000
Z
Net

Present
12%
Cash Flows PV Factors Value
Year 1
Year 2
Year 3
Year 4
Year 5
Year 6
Year 7
Year 8
Working Capital return
Salvage return
Building restoration costs
Total
Net Present Value
GRADERS: To provide for factor rounding, please allow plus or minus $2000 on this net present value solution.
Internal Rate of Return:
Year 8 + Working Capital + Salvage – Remodeling
Internal Rate of Return using Excel
Payback Period: Time for Cash
Flow to Payback
State your answer below in years and full months rounding up as necessary.
Months
Accounting Rate of Return *Working Capital requirements are not part of this calculation.

$35000
$160,000*

$300,000
$105,000

Sheet2

Sheet3

Still stressed with your coursework?
Get quality coursework help from an expert!