Consider Brighton’s results for Year 0 (see excel click here). The sales forecast for Year 1 is given in excel. In addition, Brighton plans on paying dividends of $20,000 in Year 1, they have 40,000 shares of common stock outstanding and for simplification, assume their tax expense is 35% of EBT. For Year 1, forecast Brighton’s:
Brighton Company | ||
Year 0 | Year 1 | |
Cash | 50,000.00 | |
Accounts Receivable | 275,000.00 | |
Inventory | 350,000.00 | |
Net PP&E | 800,000.00 | |
Total Assets | 1,475,000.00 | |
Accounts Payable | 80,000.00 | |
Notes Payable | 190,000.00 | |
Common Stock | 40,000.00 | |
Treasury Stock | (10,000.00) | |
Additional Paid-in Capital | 100,000.00 | |
Retained Earnings | 1,100,000.00 | |
Accumulated OCI | (25,000.00) | |
Total Liab and Equity | 1,475,000.00 | |
Sales | 1,000,000.00 | 1,200,000.00 |
Variable Expenses | (600,000.00) | |
Contribution Margin | 400,000.00 | |
Fixed Expenses | (150,000.00) | |
Operating Income | 250,000.00 | |
Nonrecurring Gain | 75,000.00 | |
Tax Expense | (113,750.00) | |
Net Income | 211,250.00 |
1. Basic Earnings per common share = Net income / shares of common stock outstanding
= $211,250 / 40,000
= $ 5.28 per share
2.
Ending Retained Earnings Calculation | |
$ | |
Beginning Retained earnings | 1,100,000.00 |
Add: Net income | 211,250.00 |
Less: Dividends | (20,000.00) |
Ending Retained earnings | 1,291,250.00 |
Consider Brighton’s results for Year 0 (see excel click here). The sales forecast for Year 1...
Year 1 wN Brighton Company Year 0 3 Cash 50,000.00 4 Accounts Receivable 275,000.00 5 Inventory 350,000.00 6 Net PP&E 800,000.00 7 Total Assets 1,475,000.00 40,000.00 80,000.00 190,000.00 40,000.00 (10,000.00) 100,000.00 1,100,000.00 (25,000.00) 1,475,000.00 40,000.00 9 Accounts Payable 10 Notes Payable 11 Common Stock 12 Treasury Stock 13 Additional Paid-in Capital 14 Retained Earnings 15 Accumulated OCI 16 Total Liab and Equity 17 18 Sales 19 Variable Expenses 20 Contribution Margin 21 Fixed Expenses 22 Operating Income 23 Nonrecurring Gain...
December 31, 2017, Sallie Ltd. (Purchase) acquires all of the assets and liabilities of Jimmie Dean Ltd. by issuing 40,000 Sallie common shares. Before the transaction, Sallie had 160,000 common shares outstanding. The market share of Sallie's stock is $30 with a par value of $10. After the transaction, 200,000 Sallie shares are outstanding, lirnrmie Dean will dissolve. The pre transaction balance sheets are the following Provide the appropriate journal entries and construct the new balance sheet for the surviving...
Consider the Throwback Company's financial results for Years 1 - 5 (see excel). ExcelData For each year, calculate the percentage change in: Net Income Comprehensive Income (Remember: Comp Inc = Net Income + Other Comp Income) Operating Cash Flow Using the percentage change for the Years 3, 4 and 5, calculate the standard deviation (assuming the population) for: Net Income Comprehensive Income Operating Cash Flow (Hint: make sure you know the difference between Estdev() and =stdevp() in excel.) Round your...
II. Problem Solving. Show all the necessary computations. No solutions, no credit. Round off final answers to two decimal places. BA220 Corporation Income Statement Sales Cost of Goods Sold Gross Profit Margin Operating Expenses Depreciation Earnings Before interest & taxes Interest Earnings Before taxes Taxes (25%) Earnings after taxes 2019 15,000,000.00 9,750,000.00 5,250,000.00 3,000,000.00 500,000.00 1,750,000.00 500,000.00 1,250,000.00 312,500.00 937,500.00 2018 12,000,000.00 7,800,000.00 4,200,000.00 2,500,000.00 400,000.00 1,300,000.00 300,000.00 1,000,000.00 250,000.00 750,000.00 2019 2018 Balance Sheet Assets Cash Accounts Receivable Inventory...
Write a narrative of up to 750 words in which you describe the following trends in the below images related to the income statement, balance sheet and financial ratios. Identify what you believe to be the most significant changes. The assignment is completed by simply describing the changes. As an option, you may speculate as to the causes of the changes. wwc Balance Sheet wwc Retained Earnings Horizontal Analysis Increase or (Decrease) 2018 over 2017 Dollars Percent Vertical Analysis Percent...
1 3 Minneapolis, Inc. is a small shop in the neighborhood that sells fruit. The owner of the shop, Ms. Foster, hired 4 you to help with her accounting. The previous accountant got married and left the company. Ms. Foster 5 was able to finish the financial statement except the statement of cash flow so she asked you to prepare the s statement of cash flow as your first job. 7 8 Ms. Foster prepared the following financial statements. 2018...
Additional data obtained from an examination of the accounts in the ledger for 20Y3 are as follows: A. The investments were sold for $175,000 cash. B. Equipment and land were acquired for cash. C. There were no disposals of equipment during the year. D. The common stock was issued for cash. E. There was a $500,000 credit to Retained Earnings for net income. F. There was a $90,000 debit to Retained Earnings for cash dividends declared. Prepare a statement of...
Book1 - Excel Home Insert Page Layout Formulas Data Review View Tell me what you want to do Calibri General Normal Ee Copy 트 ,,El Merge & Center . $ ·96 , +0-0 Conditional Format as Neutral Format Painter Formatting Table Alignment Number ACCOUNT NOTICE We've run into a problem with your Office 365 subscription, and we need your help to fix it. Reactivate A38 Required: To find the Cash paid to suppliers 1 As the accountant for MM Group...
1/1/2022 Debit Credit Cash $ 950,000.00Common Stock $ 950,000.00Cash $ 2,000,000.00Note Payable $ 2,000,000.00Inventory $ 147,000.00Accounts Payable $ 147,000.00Prepaid Rent $ 480,000.00Cash $ 480,000.00Supplies $ 10,000.00Cash $ 10,000.001/11/2022Inventory $ 3,000.00Accounts Payable $ 3,000.001/20/2022Accounts Payable $ 150,000.00Cash $ 150,000.002/10/2022Accounts Receivable $ 21,340.00Sales Revenue $ 21,340.00Cost of Goods Sold $ 15,000.00Inventory $ 15,000.00Cash $ 30,000.00Sales Revenue $ 30,000.00Cost of Goods Sold $ 21,000.00Inventory $ 21,000.003/10/2022Accounts Receivable $ 660.00Sales Revenue $ 660.003/15/2022Inventory $ 170,000.00Cash $ 170,000.004/30/2022Cash $ 30,000.00Sales Revenue $ 30,000.00Cost of Goods...
Just need help with cash flows from operating activities! The comparative balance sheet of Livers Inc. or December 31, 20Y3 and 20Y2, s as follows: Dec. 31, 20Y3 Dec.31,20Y2 1 Assets 2 $155,000.00 $150,000.00 3 Cash Accounts receivable (net) 450,000.00 400,000.00 4 770,000.00 5 Inventories 750,000.00 0.00 100,000.00 6 Investments 0.00 7Land 500,000.00 8 Equipment 1,400,000.00 1,200,000.00 9 Accumulated depreciation-equipment (600,000.00) (500,000.00) $2,675,000.00 $2,100,000.00 10 Total assets Liabilities and Stockholders' Equity 11 $340,000.00 $300,000.00 12 Accounts payable (merchandise creditors) 50,000.00...