Please tell me the price for this assignment?

1 answer below »
Answered Same DaySep 21, 2021

Answer To: Please tell me the price for this assignment?

Ishmeet Singh answered on Sep 23 2021
145 Votes
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 a
ssets                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...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here