Answered step by step
Verified Expert Solution
Question
1 Approved Answer
After completing the proforma income statement in problem 6-4, Mr. Tine now realizes he should also complete a pro forma balance sheet. Net sales in
After completing the proforma income statement in problem 6-4, Mr. Tine now realizes he should also complete a pro forma balance sheet. Net sales in 2018 were $90,000 and his forecasted sales for 2019 are $110,000. All of Sugar Cane Alley's current assets will remain the same percentage of sales as they were in 2018. Mr. Tine does not plan to buy or sell any equipment, so his gross property and equipment amount will remain the same as 2018. In the liabilities and equity section, only accounts payable will remain the same percentage of sales as in 2018. Except for retained earnings, the other accounts are expected to remain the same value as 2018. The following balances were taken from Sugar Cane Alley's end-of-2018 balance sheet: Cash Accounts Receivable Inventory Property and Equipment (gross) Accumulated Depreciation Property and Equipment (net) Accounts Payable Long-Term Notes Payable Retained Earnings Common Stock $10,000 2.220 8,000 25,000 4.000 21,000 1,380 8,000 5,000 26,840 a. Calculate the forecasted end-of-2019 values for each of the current asset accounts. b. Depreciation expense for 2019 is estimated to be $2,000. Calculate the estimated total assets for the end of 2019. c. Forecast the accounts payable for the end of 2019. d. What will total liabilities be at the end of 2019? e. Assuming the forecasted net income for 2019 is $19,351 and cash dividends paid equal $10,000, what total will be forecasted for the end-of-2019 total liabilities and equity? f. Based on these calculations of the pro forma balance sheet, are additional funds needed? g. Net income for 2018 was $14.840. What was Sugar Cane Alley's net profit margin for 2018? The forecasted net income for 2019 is $19,351. What is Sugar Cane Alley's forecasted 2019 net profit margin
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