Answer 1:-
Step 1 :- Calculations showing separation of variable and fixed portion of Cost of Goods Sold and Operating Expenses for Year 2015
(a):- Separating Variable and fixed portion of cost of goods sold for Year 2015
Particulars | Amount ($) |
Cost of Goods Sold (Total) | $2,750,000 |
Less:- Cost of Goods Sold (Fixed) | $1,000,000 |
Cost of Goods Sold (Variable) | $1,750,000 |
(b) :- Calculating Variable Cost of Goods Sold as a % of sales (Year 2015)
= Cost of Goods Sold (Variable) / Sales Revenue for Year 2015 x 100
= 1750,000 / 5,000,000 x 100
= 35% of Sales
(c) Separating Variable and fixed portion of Operating Expenses for Year 2015
Particulars | Amount ($) |
Operating Expenses (Total) | $850,000 |
Less:- Operating Expenses (Fixed) | $250,000 |
Operating Expenses (Variable) | $600,000 |
(d) : - Calculating Variable Operating Expenses as a % of sales (Year 2015)
= Operating Expenses (Variable) / Sales Revenue for Year 2015 x 100
= 600,000 / 5,000,000 x 100
= 12% of Sales
.
Step 2:- Calculations showing Cost of Goods Sold and Operating Expenses as appearing in Income statement for the year 2016
(a) Calculating Cost of Goods Sold as appearing in Income statement for year 2016
Particulars | Amount ($) |
Cost of Goods Sold (Variable) -- (35% of Sales) ---- (6,000,000 x 35% = 2,100,000) | $2,100,000 |
Add:- Cost of Goods Sold (Fixed) | $1,000,000 |
Add:- Cost of Goods Sold (Total) | $3,100,000 |
(b) Calculating Operating Expenses as appearing in Income statement for year 2016
Particulars | Amount ($) |
Operating Expenses (Variable) -- (12% of Sales) ---- (6,000,000 x 12% = 720,000) | $720,000 |
Add:- Operating Expenses (Fixed) | $250,000 |
Add:- Operating Expenses (Total) | $970,000 |
Answer 2.
a) Accounts Receivable as appearing in Proforma Balance Sheet as on December 31, 2016
= Sales Revenue for Year 2016 x 12.50%
= $6,000,000 x 12.50%
= $750,000
b) Net Fixed Assets as appearing in Proforma Balance Sheet as on December 31, 2016
Particulars | Amount ($) |
Net Fixed Asset as on December 31, 2015 | $1,400,000 |
Add:- New Assets Purchased | $356,000 |
Less:- Depreciation for Year ended 2016 | $110,000 |
Net Fixed Asset as on December 31, 2016 | $1,646,000 |
Assets Cash Marketable securities Accounts receivable Inventories Total current assets Net fixed assets Total assets Provincial...
Provincial Imports, Inc., has assembled past (2019) financial statements (income statement and balance sheet LOADING...) and financial projections for use in preparing financial plans for the coming year (2020). Information related to financial projections for the year 2020 is as follows: (1) Projected sales are $ 5,992,000. (2) Cost of goods sold in 2019 includes $ 1,000,000 in fixed costs. (3) Operating expense in 2019 includes $ 245,000 in fixed costs. (4) Interest expense will remain unchanged....
Balance Sheet ASSETS: Cash and Marketable Securities: $75.00 Accounts Receivable: $100.00 Inventories: $200.00 TOTAL CURRENT ASSETS: $375.00 Gross Property, Plant and Equipment: (blank) less Accumulated Depreciation: $50.00 NET FIXED ASSETS: (blank) TOTAL ASSETS: (blank) LIABILITIES AND EQUITY: Accounts Payable: $75.00 Notes Payable: (blank) Accruals: $75.00 TOTAL CURRENT LIABILITIES: $300.00 Long Term Debt: $350.00 TOTAL LIABILITIES: $650.00 PREFERRED STOCK: (blank) Common Stock: $50.00 Accumulated Retained Earnings: $125.00 COMMON EQUITY: $175.00 TOTAL LIABILITIES AND EQUITY: $875.00 1. Consider the balance sheet above:...
Pro forma balance sheet Peabody & Peabody has 2015 sales of $10.3 million. It wishes to analyze expected performance and financing needs for 2017—2 years ahead. Given the following information, respond to parts a. and b. (1) The percents of sales for items that vary directly with sales are as follows: Accounts receivable; 12.2%, Inventory: 17.7%, Accounts payable, 13.6%; Net profit margin, 3.4%. (2) Marketable securities and other current liabilities are expected to remain unchanged. (3) A minimum cash balance...
ntegrative—Pro forma statements Provincial Imports, Inc., has assembled past (2019) financial statements (income statement and balance sheet LOADING...) and financial projections for use in preparing financial plans for the coming year (2020).Information related to financial projections for the year 2020 is as follows:(1) Projected sales are $6,007,000.(2) Cost of goods sold in 2019 includes $991,000 in fixed costs.(3) Operating expense in 2019 includes $253,000 in fixed costs.(4) Interest expense will remain unchanged.(5) The firm will pay cash dividends amounting to 40% of net...
P4-18 (similar to) Question Help Pro forma balance sheet Peabody & Peabody has 2015 sales of $10.5 million. It wishes to analyze expected performance and financing needs for 2017-2 years ahead. Given the following information, respond to parts a. and b. (1) The percents of sales for items that vary directly with sales are as follows Accounts receivable; 12.1% Inventory: 18.4%; Accounts payable, 14.4%; Net profit margin, 3.1%. (2) Marketable securities and other current liabilities are expected to remain unchanged...
Pro forma balance sheet Peabody & Peabody has 2019 sales of $10.2 million. It wishes to analyze expected performance and financing needs for 2021—2 years ahead. Given the following information, respond to parts a. and b. (1) The percents of sales for items that vary directly with sales are as follows: Accounts receivable; 12.4%, Inventory; 18.4%; Accounts payable, 13.8%; Net profit margin, 3.3%. (2) Marketable securities and other current liabilities are expected to remain unchanged. (3) A minimum cash balance...
Pro forma balance sheet-Basic Leonard Industries wishes to prepare a pro forma balance sheet for December 31, 2020. The firm expects 2020 sales to total $3,000,000. The following information has been gathered. (1) A minimum cash balance of $49,500 is desired. (2) Marketable securities are expected to remain unchanged. B) Accounts receivable represent 10.1% of sales. (4) Inventories represent 12.1% of sales. (5) A new machine costing $90,200 will be acquired during 2020. Total depreciation for the year will be...
5248,000 225,000 756,400 754.358 Cash Marketable Equity Securities (Note 1) Accounts Receivable-Net (Note 2) Inventories (Note 3) Total Current Assets 374,000 954,950 102,000 Investment in Nowell Co.(15-percent owned) Investment in Knight Co.(25-percent owned) Total Investments 377.000 110,000 743,000 110,000 743,000 1,961,852 267.600) 1,151,692 Total Plant Assets at Cost Plant Assets-Net Total Assets IABILITIES AND SHAREHOLDERS' EQUITY $140,000 535,157 118,000 $100,000 493.296 75,000 40,000 Notes Payable Accounts Payable Rental Fees Received in Advance Income Taxes Payable Total Current Liabilities 1,172,924 1.166,635...
Pro forma balance sheet Peabody & Peabody has 2019 sales of $10.6 million. It wishes to analyze expected performance and financing needs for 2017, 2 years ahead. Given the following information, respond to parts a. and b. (1) The percents of sales for items that vary directly with sales are as follows: Accounts receivable; 11.5%, Inventory;17.6%; Accounts payable;14.2%; Net profit margin; 2.9%. (2) Marketable securities and other current liabilities are expected to remain unchanged. (3) A minimum cash balance of...
Pro forma balance sheet: Basic Leonard Industries wishes to prepare a pro forma balance sheet for December 31, 2020. The firm expects 2020 sales to total $3,000,000. The following information has been gathered: (1) A minimum cash balance of $50,000 is desired. (2) Marketable securities are expected to remain unchanged. (3) Accounts receivable represent 10% of sales. (4) Inventories represent 12% of sales. (5) A new machine costing $90,000 will be acquired during 2020. Total deprecia- tion for the year...