Answer To: Please tell me the price for this assignment?
Ishmeet Singh answered on Sep 23 2021
Input
Telstra Airways
Ratio Analysis
Input Worksheet
9/23/20
Gray cells will be calculated for you. You do not need to enter anything into them.
Line Item 2019 2018 2017
Current assets 7,303,000 7,077,000 7,862,000
Fixed assets 22,332,000 22,108,000 21,350,000
Total assets 42,589,000 42,870,000 42,133,000
Average total assets 42,589,000 42,729,500 42,501,500
Cash and cash equivalents 604,000 629,000 938,000
Inventory 448,000 801,000 893,000
Average inventory 448,000 624,500 847,000
Current liabilities 9,553,000 8,816,000 9,159,000
Total liabilities 28,059,000 27,856,000 27,573,000
Owners' equity 14,549,000 15,027,000 14,541,000
Number of common shares 4,447,000 4,428,000 4,421,000
Average number of common shares 4,447,000 4,437,500 4,424,500
Average owners' equity 14,549,000 14,788,000 14,784,000
Market price per share 12.10 14.00 19.00
Cash flow 3,568,000 3,568,000 2,313,000
Cash flow per share 0.80 0.80 0.52
Dividends paid 1,926,000 1,926,000 2,259,000
Total sales 25,259,000 26,011,000 26,013,000
Operating expenses 13,545,000 14,043,000 14,022,000
Operating income 11,714,000 11,968,000 11,991,000
Advertising expense 3,286,000 3,628,000 3,433,000
Marketing expense 4,000,000 4,000,000 4,000,000
Earnings before interest and taxes 3,072,000 5,102,000 5,647,000
Interest expense 868,000 631,000 729,000
Net income 2,154,000 3,563,000 3,891,000
Total loan 28,059,000 27,856,000 27,573,000
Value of collateral or property 22,332,000 22,108,000 21,350,000
Liquidity
Telstra Airways
Ratio Analysis
Liquidity Ratios 2019 2018 Q2 2017
Definition:
Current Ratio = Current Assets 0.76 = $7,303,000 0.80 = $7,077,000 0.86 = $7,862,000
Current Liabilities $9,553,000 $8,816,000 $9,159,000
Industry Average 2.00 2.00 2.00
Variance (1.24) (1.20) (1.14)
Quarterly Growth/Decline 0.04 0.06
Quick Ratio = Current Assets – Inventory 0.72 = $7,303,000 - $448,000 0.71 = $7,077,000 - $801,000 0.76 = $7,862,000 - $893,000
Current Liabilities $9,553,000 $8,816,000 $9,159,000
Industry Average 7.00 7.00 7.30
Variance (6.28) (6.29) (6.54)
Quarterly Growth/Decline (0.01) 0.05
Net Working Capital Ratio = Current Assets – Current Liabilities (0.05) = $7,303,000 - $9,553,000 (0.04) = $7,077,000 - $8,816,000 (0.03) = $7,862,000 - $9,159,000
Total Assets $42,589,000 $42,870,000 $42,133,000
Industry Average 2.00 2.00 2.00
Variance (2.05) (2.04) (2.03)
Quarterly Growth/Decline 0.01 0.01
Current Liabilities to Inventory Ratio = Current Liabilities 21.32 = $9,553,000 11.01 = $8,816,000 10.26 = $9,159,000
Inventory $448,000 $801,000 $893,000
Industry...