Financial questions

profilejonknee
assignment_12.xlsx

Sheet1

Problem 12-1
9200000
4600000
900000
1035000
0.575 1200000 0.129375 1200000 193200
341,550.00
Problem 12-2
Prolem 12-3
Sales expected 9,200,000.00
After-tax profit margin
(9200000*4%) 368,000.00
Dividend payments 147,200.00
(368000*40%)
Additional to retained earnings
(368000-147200) 220,800.00
Increase in assets
(4000000*15%) 600,000.00
Increase in liabilities
(450000+450000)*15% 135,000.00
AFN 244,200.00

Sheet2

Sheet3

1

2

3

4

5

6

7

8

9

A

B

C

D

E

Problem 12-1

9200000

4600000

900000

1035000

0.575

1200000