Financial Analysis and Investment Appraisal Techniques for Proposed Project

Running head: FINANCE
Finance
Name of the Student:
Name of the University:
Authors Note:

FINANCE
1
Table of Contents
1. Calculating the spreadsheet financial analysis of the proposed project:................................2
2. Conducting Memo to Pinto’s CEO explaining and justifying the recommendation for the
proposed project:........................................................................................................................4
Reference and Bibliography:......................................................................................................9

FINANCE
2
1. Calculating the spreadsheet financial analysis of the proposed project:
Particulars 0 1 2 3 4 5
Sales Volume
200,000.
00
300,000
.00
450,000
.00
22
5,000.00
112,
500.00
Sales price $
75.00
$
77.25
$
79.57
$
81.95
$
84.41
Revenue $
15,000,0
00.00
$
23,175,
000.00
$
35,805,
375.00
$
18,439,768.
13
$
9,496,480
.58
Cost of goods sold $
9,000,00
0.00
$
13,905,
000.00
$
21,483,
225.00
$
11,063,860.
88
$
5,697,888
.35
General and
administrative
expenses
$
1,000,00
0.00
$
1,050,0
00.00
$
1,102,5
00.00
$
1,157,625.0
0
$
1,215,506
.25
Rent $
250,000.
00
$
250,000
.00
$
250,000
.00
$
250,000.00
$
250,000.0
0
Depreciation $
3,000,00
0.00
$
3,000,0
00.00
$
3,000,0
00.00
$
3,000,000.0
0
$
3,000,000
.00
PBT $
1,750,00
$
4,970,0
$
9,969,6
$
2,968,282.2
$
(666,914.