Solution
Ishmeet Singh answered on
Oct 14 2021
Input
CTM
Financial Analysis
Input Worksheet
10/14/20
Gray cells will be calculated for you. You do not need to enter anything into them.
2020 2019 2018
Line Item Year 1 Year 2 Year 3
Cu
ent assets 92,843 138,791 84,297
Fixed assets 89,737 32,215 20,243
Total assets 763,517 1,003,849 804,841
Average total assets 763,517 883,683 904,345
Cash and cash equivalents 92,843 138,791 84,297
Inventory 0 0 0
Average inventory 0 0 0
Cu
ent liabilities 142,997 367,834 291,394
Total liabilities 205,430 411,367 333,349
Owners' equity 143,345 177,190 133,218
Number of common shares 375,314 364,368 301,747
Average number of common shares 375,314 369,841 333,058
Average owners' equity 143,345 160,268 155,204
Market price per share 12.13 12.43 21.62
Cash flow 138,791 92,843 138,791
Cash flow per share 0.37 0.25 0.42
Dividends paid 45,271 26,456 45,271
Total sales 446,739 314,395 446,739
Operating expenses 328,395 328,395 325,779
Operating income 118,344 -14,000 120,960
Advertising expense 161,099 145,748 200,000
Marketing expense 100,000 100,000 61,099
Earnings before interest and taxes 120,939 -11,753 120,939
Interest expense 2,765 9,620 2,765
Net income 86,235 -8,185 86,235
Total loan 0 39,290 43,978
Value of collateral or property 58,919 13,328 6,118
Liquidity
CTM
Ratio Analysis
Liquidity Ratios Year 1 Year 2 Q2 Year 3
Definition:
Cu
ent Ratio = Cu
ent Assets 0.65 = $92,843 0.38 = $138,791 0.29 = $84,297
Cu
ent Liabilities $142,997 $367,834 $291,394
Industry Average 2.00 2.00 2.00
Variance (1.35) (1.62) (1.71)
Quarterly Growth/Decline (0.27) (0.09)
Quick Ratio = Cu
ent Assets – Inventory 0.65 = $92,843 - $0 0.38 = $138,791 - $0 0.29 = $84,297 - $0
Cu
ent Liabilities $142,997 $367,834 $291,394
Industry Average 7.00 7.00 7.30
Variance (6.35) (6.62) (7.01)
Quarterly Growth/Decline (0.27) (0.09)
Net Working Capital Ratio = Cu
ent Assets – Cu
ent Liabilities (0.07) = $92,843 - $142,997 (0.23) = $138,791 - $367,834 (0.26) = $84,297 - $291,394
Total Assets $763,517 $1,003,849 $804,841
Industry Average 2.00 2.00 2.00
Variance (2.07) (2.23) (2.26)
Quarterly Growth/Decline (0.16) (0.03)
Cu
ent Liabilities to Inventory Ratio = Cu
ent Liabilities 0.00 = $142,997 0.00 = $367,834 0.00 = $291,394
Inventory $0 $0 $0
Industry Average 2.00 2.00 2.00
Variance 0.00 0.00 0.00
Quarterly Growth/Decline 0.00 0.00
Cash...