Hi, I will take a final test on this coming Saturday 10:00AM, at DEC 19 (U.S New York time) this course is Advanced Investment Analysis (Financial & Valuation Analysis) The exam will be given 2 hours...

Sheet1
        FINAL EXAM                                        Randomized Exam #                    100                                                                                                                                            47.7997995795    3    1    2    3        1020333
        Last Name:    Kim                First Name:    Daehee                48                91                                                                                                                                                Question    300    340    320    300
        File Name:    C:\Users\DELL\Desktop\[kmidhee.xlsx]Sheet1                                                                                                                                                                                                        30    50    40    30
                                                                                                                                                                                                                    30    50    40    30
        DO NOT INSERT LINES OR COLUMNS. USE THE WHITE SPACE ON THE RIGHT FOR YOUR CALCULATION NOTES                                                                                                                                                                                                             40    60    50    40
                                                                                                                                                                                                                    40    50    40    40
        SECTION I - FINANCIAL ANALYSIS (35 POINTS)                                                                                                                                                                                                            90    110    100    90
                                                                                                                                                                                                                    3    5    4    3
        Question 1 (25 points)                                                                                                                                                                                                            5    7    6    5
        Prepare the Cash Flow Statement and Ratio Analysis                                                                                                                                                                                                             8    10    9    8
                                                                                                                                                                                                                    1    3    2    1
        Balance Sheet (000's)                    Income Statement (000's)                                                                                                                                                                                        2    1.9    1.8    2
                2018    2019                    2018    2019                                                                                                                                                                        10    13    12    10
        Cu
ent Assets                    Revenues by Product
         Cash        70,000    95,000        Bioscensors            1,000,000    1,200,000
         Accounts Receivable        72,500    88,000        Devices            200,000    220,000
         Inventories        57,500    68,000        Services            50,000    80,000
         Prepaid Expenses        13,000    14,000        Total Revenue            1,250,000    1,500,000
        Other Cu
ent Assets Expenses        12,000    11,000
        Total Cu
ent Assets        225,000    276,000
                            Cost of Revenues by Geography
        Property and Equipment                    Bioscensors            300,000    350,000
         Land        3,750,000    3,750,000        Devices            150,000    166,000
         Building        675,000    800,000        Services            35,000    54,000
         Furniture & Equipment        75,000    100,000        Total Cost of Revenue            485,000    570,000
        Total Gross P&E        4,500,000    4,650,000
        Less Accumulated Depreciaition        (450,000)    (550,000)        Gross Profit            765,000    930,000
        Net P&E        4,050,000    4,100,000
                            Operating Expenses
        Long-Term Investments        300,000    378,580         Administrative & General            217,500    250,000
                             Marketing Expenses            112,500    120,000
        Total Assets        4,575,000    4,754,580         Other Operating Expenses            15,000    18,000
                            Total Operating Expenses            345,000    388,000
        Liabilities and Owners Equity
                            EBITDA            420,000    542,000
        Cu
ent Liabilities
         Accounts Payable        55,000    68,900        Depreciation            90,000    100,000
         Accrued Income Taxes        23,000    27,000
         Accrued Expenses        13,000    11,000        EBIT            330,000    442,000
        Other Cu
ent Liabilities        12,000    11,000
         Cu
ent Portion of Long Term Debt        35,000    23,000
        Total Cu
ent Liabilities        138,000    140,900        Interest Expense            144,000    136,000
        Long-Term Debt:        1,800,000    1,700,000        EBT            186,000    306,000
        Defe
ed Income Taxes        18,000    16,000        Taxes            40,920    67,320
        Total Liabilties        1,956,000    1,856,900        Net Income            145,080    238,680
        Owners' Equity
         Common Stock        1,500,000    1,500,000
         Paid-in-Capital        -    40,000
         Retained Earnings        1,119,000    1,357,680
        Total Owners' Equity        2,619,000    2,897,680
        Total Liabilities & Owner's Equity        4,575,000    4,754,580
            E
or...