Answer To: Hi, I will take a final test on this coming Saturday 10:00AM, at DEC 19 (U.S New York time) this...
Himanshu answered on Dec 19 2021
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
Current 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 Current Assets Expenses 12,000 11,000
Total Current 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
Current 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 Current Liabilities 12,000 11,000
Current Portion of Long Term Debt 35,000 23,000
Total Current 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
Deferred 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
Error...