Description
I need assistance in completing my Finance project, I attached the instruction. Thank you!
Unformatted Attachment Preview
Purchase answer to see full attachment
Explanation & Answer
Hey There,Please find the attached.
Corporate Finance Outline
Part 1: El Cap Climbing Company
•
Income Statement
•
Balance Sheet
•
Cashflows Statement
•
Answers to question
Part 2: Mortgage Decision
•
Loan Amortization Schedule
•
Chart
•
Answers to question
Part 3: Can We Upgrade
•
Computations
•
Answers to questions
Part 4: Risky Business
•
Scatter graph
•
Regression Analysis
•
Answers to questions
Cost of Goods Sold
Cash
Depreciation
Interest Expense
Selling and Admin Exp
Accounts Payable
Net Fixed Assets
Sales
Accounts Receivable
Notes Payable
Long-Term Debt
Inventory
New Equity
2015
235.942
36.542
61.056
13.877
40.952
32.194
269.369
482.155
24.120
24.866
142.148
32.766
0
El Cap Climbing Company
Income Statement
For The Year Ending
2015
$
Sales
482.155,00
Less: Cost of Sales
(235.942,00)
Gross Profit
246.213,00
Selling and Admin Exp
40.952,00
Depreciation
61.056,00
Profit From Operations
144.205,00
Interest Expense
13.877,00
Profit before taxes
130.328,00
Taxes
39.098,40
Profit After Taxes
91.229,60
Dividends
36.491,84
54.737,76
Retained Earnings b/f
Retained Earnings c/d
54.737,76
2016
297.915
51.940
69.011
15.905
58.569
33.999
328.185
587.715
24.089
26.972
161.000
58.798
16.000
Change
2016
$
587.715,00
(297.915,00)
289.800,00
58.569,00
69.011,00
162.220,00
15.905,00
146.315,00
43.894,50
102.420,50
40.968,20
61.452,30
54.737,76
95.705,96
105.560,00
(61.973,00)
43.587,00
17.617,00
7.955,00
18.015,00
2.028,00
15.987,00
4.796,10
11.190,90
4.476,36
6.714,54
54.737,76
40.968,20
% Change
21,89%
26,27%
17,70%
43,02%
13,03%
12,49%
14,61%
12,27%
12,27%
12,27%
12,27%
12,27%
100,00%
74,84%
B) The company performance is generally good as it represent a positive growth for
the income statement where revenue had 21.89 % and Gross profit increase by
17.70% as well as the profit before tax growth for 12.27%.
C) Leah she should embark on the expansion this is due to the postive change in
income statement and the balance sheet.
El Cap Climbing Company
Income Statement
For The Year Ending
2015
$
2016
$
ASSETS
Non Current Assets
Net Fixed Assets
Current Assets
Accounts Receivable
Inventory
Cash
Total Assets
269.369,00
269.369,00
328.185,00
328.185,00
24.120,00
32.766,00
36.542,00
93.428,00
362.797,00
24.089,00
56.789,00
51.940,00
132.818,00
461.003,00
108.851,24
54.737,76
163.589,00
127.326,04
16.000,00
95.705,96
239.032,00
142.148,00
142.148,00
161.000,00
161.000,00
32.194,00
24.866,00
57.060,00
362.797,00
33.999,00
26.972,00
60.971,00
461.003,00
Equity And Liabilities
Capital
Equity
New Equity
Retained Earnings
Non Current Liabilities
Long-Term Debt
Current Liabilities
Accounts Payable
Notes Payable
Total Equity and Liabilities
El Cap Climbing Company
Cashflow Statement
For The Year Ending
2015
Cashflows From Operating Activities
Net Income
Adjustments
Depreciation
Interest Expense
Operating Profit before change in working capital
2016
130.328,00
146.315,00
61.056,00
13.877,00
205.261,00
69.011,00
15.905,00
231.231,00
(Increase)/Decrease in Debtors and other receivables
(137.764,00)
Increase/(Decrease) in Creditors and other payables
Cash Generated from operations
3.911,00
97.378,00
Taxes
Interest Paid
Net Cashflows From Operations
(43.894,50)
(15.905,00)
37.578,50
Cashflow From Investing Activities
Purchase of Equipments
Equity Issued
Net Cashflows From Investing
(58.816,00)
16.000,00
(42.816,00)
Cash Flow From Financing Activities
Long Term Loan
Net Cashflow From Financing Activities
18.852,00
18.852,00
Net Increase in Cash
Cash b/f
Cash c/d
15.398,00
36.542,00
51.940,00
Change
% Change
58.816,00
21,83%
58.816,00
21,83%
(31,00)
-0,13%
24.023,00
73,32%
15.398,00
42,14%
39.390,00
42,16%
98.206,00
27,07%
18.474,80
16,97%
16.000,00 100,00%
40.968,20
74,84%
75.443,00
46,12%
18.852,00
13,26%
18.852,00
13,26%
1.805,00
5,61%
2.106,00
8,47%
3.911,00
6,85%
98.206,00
27,07%
Payment
Number
0
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
Payment
Amount
2.684,11
2.684,11
2.684,11
2.684,11
2.684,11
2.684,11
2.684,11
2.684,11
2.684,11
2.684,11
2.684,11
2.684,11
2.684,11
2.684,11
2.684,11
2.684,11
2.684,11
2.684,11
2.684,11
2.684,11
2.684,11
2.684,11
2.684,11
2.684,11
2.684,11
2.684,11
2.684,11
2.684,11
2.684,11
2.684,11
2.684,11
2.684,11
2.684,11
2.684,11
2.684,11
2.684,11
2.684,11
2.684,11
2.684,11
5% Interest
Expense
2.083,33
2.080,83
2.078,32
2.075,79
2.073,26
2.070,71
2.068,16
2.065,59
2.063,01
2.060,43
2.057,83
2.055,22
2.052,60
2.049,97
2.047,32
2.044,67
2.042,01
2.039,33
2.036,64
2.033,95
2.031,24
2.028,52
2.025,78
2.023,04
2.020,29
2.017,52
2.014,74
2.011,95
2.009,15
2.006,34
2.003,52
2.000,68
1.997,83
1.994,97
1.992,10
1.989,22
1.986,32
1.983,42
1.980,50
Principal
600,78
603,28
605,79
608,32
610,85
613,40
615,95
618,52
621,10
623,68
626,28
628,89
631,51
634,14
636,79
639,44
642,10
644,78
647,47
650,16
652,87
655,59
658,33
661,07
663,82
666,59
669,37
672,16
674,96
677,77
680,59
683,43
686,28
689,14
692,01
694,89
697,79
700,69
703,61
Balance
500.000,00
499.399,22
498.795,94
498.190,15
497.581,83
496.970,98
496.357,58
495.741,63
495.123,11
494.502,01
493.878,33
493.252,04
492.623,15
491.991,64
491.357,49
490.720,70
490.081,26
489.439,16
488.794,38
488.146,91
487.496,75
486.843,87
486.188,28
485.529,96
484.868,89
484.205,06
483.538,47
482.869,11
482.196,95
481.522,00
480.844,23
480.163,64
479.480,21
478.793,93
478.104,80
477.412,79
476.717,90
476.020,11
475.319,42
474.615,81
Annual Interest
Expense
24.832,47
24.455,06
24.058,33
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
2.684,11
2.684,11
2.684,11
2.684,11
2.684,11
2.684,11
2.684,11
2.684,11
2.684,11
2.684,11
2.684,11
2.684,11
2.684,11
2.684,11
2.684,11
2.684,11
2.684,11
2.684,11
2.684,11
2.684,11
2.684,11
2.684,11
2.684,11
2.684,11
2.684,11
2.684,11
2.684,11
2.684,11
2.684,11
2.684,11
2.684,11
2.684,11
2.684,11
2.684,11
2.684,11
2.684,11
2.684,11
2.684,11
2.684,11
2.684,11
2.684,11
2.684,11
2.684,11
2.684,11
1.977,57
1.974,62
1.971,67
1.968,70
1.965,72
1.962,72
1.959,72
1.956,70
1.953,67
1.950,62
1.947,57
1.944,50
1.941,42
1.938,32
1.935,22
1.932,10
1.928,96
1.925,82
1.922,66
1.919,48
1.916,30
1.913,10
1.909,89
1.906,66
1.903,42
1.900,17
1.896,90
1.893,62
1.890,33
1.887,02
1.883,70
1.880,36
1.877,01
1.873,65
1.870,27
1.866,88
1.863,48
1.860,06
1.856,63
1.853,18
1.849,72
1.846,24
1.842,75
1.839,24
706,54
709,49
712,44
715,41
718,39
721,39
724,39
727,41
730,44
733,49
736,54
739,61
742,69
745,79
748,89
752,01
755,15
758,29
761,45
764,63
767,81
771,01
774,22
777,45
780,69
783,94
787,21
790,49
793,78
797,09
800,41
803,75
807,10
810,46
813,84
817,23
820,63
824,05
827,48
830,93
834,39
837,87
841,36
844,87
473.909,27
473.199,78
472.487,33
471.771,92
471.053,53
470.332,14
469.607,75
468.880,34
468.149,89
467.416,41
466.679,87
465.940,26
465.197,56
464.451,78
...