Question

Prepare a Balance Sheet with an ending date of July 31, 2020 based on the following information:

1) marketable security 26480

2). Scholarship fund 121947

3) Customers owe 25000

4) Building has 8 yea service life

5) land sold at 13% over market value

6) Furniture bought February 1,2020 16000

7) cash equals sell of land

8) Note receivable 54000

9) Insurance bought for 3 years July 1, 2017 100000

10) 20% of customer debt not collectible

11) land appreciates at 7 ½% each year

12) building bought August 1, 2019 720000

13) patent royalty 55,000

14) land purchased January 1, 2017 2,500,000

15) Furniture 4 year service life

16) copyright 17432

17) equipment purchased April 1, 2018 340,000

18) purchase of supplies 97104

19) common @ 113/each

20) wages 16247

21) preferred@ 226/each

22) retained earnings 2456789

23) equipment 20 year service life

24) commissions 87009

25) long term loan 1165430

26) common sold 255 shares

27) building mortgage 612866

28) preferred sold 357 shares

29) taxes owed 6700 + 1% land purchase

30) note payable 1/6 of note receivable

31 )merchandise inventory 3470

2. Prepare an Income Statement based on the following information:

• Gross Sales = 1,573,200
• Cost of goods sold = 20% of inventory from balance sheet
• Depreciation (building) = 1year of depreciation for building from balance sheet
• Discounts on sales = 19,780
• Sales expense = 14% of net sales
• Returns = 420,048
• Interest expense = 6 ¼ % of gross sales
• Administrative expense =35,790
• Income from other sources = 233,577
• Taxes = 33 ½ %

B] Using the information above find the Return on Sales ratio. Is that ration favorable? Explain.

1. Prepare a Cash Flow Statement based on the following information:

• Net income = net income determined in your Income statement
• Payment of dividends = 40% of value of preferred shares from your balance sheet
• Increase in Accounts receivables = 1.15% of Accounts Receivables from your balance sheet
• Sale of Investments = (1000)
• Decrease in inventory = 65% of inventory balance from your balance sheet
• Depreciation = depreciation value determined in your income statement
• Beginning year cash balance = twice your net income

Answer 1

1	Assets	Amount
	Marketable Security	26,480.00
	Scholarship Fund	121,947.00
	Account Receivable	25,000.00
	Provision for Bad Debts	(5,000.00)
	Note Receivable	54,000.00
	Cash	3,342,980.00
	Building	720,000.00
	Accumulated Depreciation on Building	(90,000.00)
	Furniture	16,000.00
	Accumulated Depreciation on Furniture	(2,000.00)
	Equipment	340,000.00
	Accumulated Depreciation on Equipment	(39,667.00)
	Inventory	3,470.00
	Patent Royalty	55,000.00
	Copyright	17,432.00
	Total Assets	4,585,642.00
	Liabilities	Amount
	Accounts Payable	97,104.00
	Wages Payable	16,247.00
	Commissions	87,009.00
	Long term loan	1,165,430.00
	Notes Payable	9,000.00
	Building Mortgage	612,866.00
	Taxes Owed	31,700.00
	Common Shares	28,815.00
	Preferred Shares	80,682.00
	Retained Earnings	2,456,789.00
	Total Liabilities	4,585,642.00
2	Income Statement	Amount
	Gross Sales	1,573,200.00
	Discount	(19,780.00)
	Sales	1,592,980.00
	Returns	(420,048.00)
	Net Sales	1,172,932.00
	Other Income	233,577.00
	Total Income	1,406,509.00
	Cost of Goods Sold	694.00
	Depreciation of Building	90,000.00
	Sales Expenses	164,210.48
	Interest Expenses	98,325.00
	Administrative Expense	35,790.00
	Total Expenses	389,019.48
	Net Profit	1,017,489.52
	Taxes @ 33.5%	340,858.99
	Profit After Taxes	676,630.53