You have the following fina information to answer the following que e following financial information about Berkeley answer the following questions Sales Net Fixed Assets Inventory Cost of Goods Sold Interest Cash Common Stock (APIC) Depreciation Accounts Receivable Accounts Payable Long-Term Debt Tax Rate Dividends Common Shares Outstanding Book Value Per Share Price / Earnings Multiple (PE) Berkeley Automobile Company Inc. (000's) 2019 2018 $ 14,000 $ 9,500 $ 10,800 $ 9,650 $ 3,100 $ 4,513 $ 6,900 $ 9,242 $ 300 $ 390 $ 575 $ 550 $ 2,500 $ 2,500 $ 375 $ 355 $ 1,600 $ 4,891 $ 2,400 $ 3,750 $ 3,500 $4,145 34% 34% $ 824 $ 1,115 200 200 $ 50.88 $ 58.54 10 11 All balance sheet items are as of 12/31 of that year All income statement items are for the entire year indicated Please complete the asset portion of the balance sheet for Berkeley Automobile Inc. for 2018 and 2019. Enter the balance sheet categories on the "Description" column and the dollar amounts in the "Year" column. Make sure you complete the totals where requested (10 Points). please complete the liabilities portion of the balance sheet for Berkeley Automobile Inc 18 and 2019. Enter the balance sheet categories on the Description dollar amounts in the Year" column. Make sure you complete the totals where requested (5 Points). TIL. Please complete the Shareholder's Equi Automobile Inc. for 2018 and 2019. Ente amnlete the Shareholder's Equity portion of the balance sheet for Bett while Inc for 2018 and 2019. Enter the balance sheet categories on the ollar amounts in the "Year" column. Make sure you Description" column and the dollar amounts in the Year" column. Make complete the totals where requested (10 Points). IV. Please complete the income Statement for Berkeley Automobile, Inc from the financial information given above, on the "Description" column and the dollar amounts in the Year column. Please give subtotals where requested in bold (EBITDA, EBIT, EBT, Net Income). Remember you may have to calculate some values. (20 Points) 12/31/2018 Amount 12/31/2019 Amount Description EBITDA EBIT EBT Net Income 5. What is Berkeley Automobile's Net Working Capital for 2018 and 2019? Please show work (5 points) 2018: 2019: 6. What is Berkeley Automobile's dividend payout ratio for 2018 and 2019? What is its "plowback' ratio to retained earnings? Please show work (5 Points). 2018 2019 Dividend Payout Ratio Plowback Ratio 7. What is Berkeley Automobile's Operating Cash Flow (OCF) for 2019? Please show work (5 points). 8. What is Berkeley Automobile's Net Capital Spending (NCS) in 2019? Please show work (5 points). w from feed assets (CFA) for 2019? What portion went to 9. What is Berkeley Automobiles cash creditors? what portion to store 2019 CFFA- stockholders? (10 points) Cash flow to creditors: Cash flow to stockholders: 10. Has Berkeley Automobile's profi points) obile's profit margin improved from 2018 to 2019? Please show work (5 Berkeley Automobile's internal growh rate for 2018 and 2019? What is Berkeley Automobile's sustainable growth rate for 2018 and 2019? (10 points) 2018 2019 Internal Growth Rate Sustainable Growth Rate 12. Based upon its price earnings multiple (PE ratio), what is the market price of its stock at the end of 2018 and 2019? (5 points) 2018: 2019 pg. 6 Assessment wib eley Automobile had one of its best yearly performances in 20191 acement has decided that it would like to reward its shareholders and make a special payout (dividend). This special "one-time dividend is payable on Jan. 15th, 2020", in the amount of $3 million will the company need external financing to pay this one-time dividend on Jan. 15, 2020? How much external financing (EFN) would they need for Jan. 15, 2020? (Show work) (5 points). Extra Credit: (10 points) Reconcile the Statement of Cash Flows for Berkeley Automobile Inc. for 2019. Cash, beginning of year $575 Operating Activities Investment Activities Financing Activities $550 Cash, end of year
