Question
You have the following financial information about Berkeley Automobile Company. Please use this information to answer the following questions Berkeley Automobile Company Inc. (000's) 2018
You have the following financial information about Berkeley Automobile Company.
Please use this information to answer the following questions Berkeley Automobile Company Inc.
(000's) 2018 2019 Sales $ 9,500 $ 14,000 Net Fixed Assets $ 10,800 $ 9,650 Inventory $ 3,100 $ 4,513 Cost of Goods Sold $ 6,900 $ 9,242 Interest $ 300 $ 390 Cash $ 575 $ 550 Common Stock (APIC) $ 2,500 $ 2,500 Depreciation $ 375 $ 355 Accounts Receivable $ 1,600 $ 4,891 Accounts Payable $ 2,400 $ 3,750 Long-Term Debt $ 3,500 $ 4,145 Tax Rate 34% 34% Dividends $ 824 $ 1,115 Common Shares Outstanding 200 200 Book Value Per Share $ 50.88 $ 58.54 Price / Earnings Multiple (PE) 10 11
All balance sheet items are as of 12/31 of that year
All income statement items are for the entire year indicated I.
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).
II. Please complete the liabilities 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 (5 Points). III.
Please complete the Shareholders Equity 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). 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).
5. What is Berkeley Automobiles Net Working Capital for 2018 and 2019? Please show work (5 Points). 2018: 2019: 6.
What is Berkeley Automobiles 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 Automobiles Operating Cash Flow (OCF) for 2019? Please show work (5 points).
8. What is Berkeley Automobiles Net Capital Spending (NCS) in 2019? Please show work (5 points).
9. What is Berkeley Automobiles cash flow from fixed assets (CFFA) for 2019? What portion went to creditors? what portion went to stockholders? (10 points) 2019 CFFA = Cash flow to creditors: Cash flow to stockholders:
10. Has Berkeley Automobiles profit margin improved from 2018 to 2019? Please show work (5 points).
11. What is Berkeley Automobiles internal growh rate for 2018 and 2019?
What is Berkeley Automobiles 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:
13. Berkeley Automobile had one of its best yearly performances in 2019!! Management 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. 15th, 2020? How much external financing (EFN) would they need for Jan. 15th, 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 Cash, end of year $550 Supplemental
Tables for Parts I,II,III,IV from above listed below:
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started