calculate the balance sheet from the following

calculate a balance sheet (I have only this information)

i add balance sheet for old period

I have this information about my company and i have to prepare a balance sheet

5 2,500 0 0 3,750 6,250 33,336 6,664 0 1,000 20,000 9,500 70,500 6,251 Depreciation on property Depreciation on equipment Depreciation on plant Depreciation on distribution channels Depreciation Remuneration for salesstaff Social security and national insurance contributions salesstaff Other sales costs Depreciation costs on sales department Marketing costs Market research Sales costs Remuneration for general departments Social security and national insurance contributions general departments Other general costs Depreciation on general departments Bad debts and provisions Product research and development Production volume variance Quality costs Cost for warehousing General administration costs Cost of products Cost of sales Change in inventory ready for sale 1,250 15,100 5,250 0 11,300 0 6,760 4,048 49,958 203,800 150,743 53,057 Income statement 5 Net turnover Cost of sales Gross sales margin 333,865 150,743 183,122 70,500 49,958 120,458 62,664 0 0 0 20,400 -20,400 Sales costs General administration costs Sum of costs Operating profit Other company revenues Other company costs Interest revenue Interest costs Net financing costs / income Operational earnings before taxes Taxes over operational earnings Operational earnings Exceptional losses and profits Taxes over exceptional result Exceptional result after taxes Net profit 42,264 0 42,264 0 0 42,264 5 Cash flow from operational activities Accounts receivable Interest received Other income 331,890 0 0 331,890 Cost for warehousing Accounts payable Remuneration Interest paid Quality costs Marketing costs Other costs Research and development costs 4,048 203,800 47,500 20,400 6.760 29,500 15,100 11,300 338,408 -6,518 0 Cashflow from financing activities Change in short-term debt Change in long-term debt Change in investments 100,000 0 100,000 Cash flow from investment activities Investment in property Investment in equipment Investment in plants Change in cash 93,482 5 Cash flow from operational activities Accounts receivable Interest received Other income 331,890 0 0 331,890 Cost for warehousing Accounts payable Remuneration Interest paid Quality costs Marketing costs Other costs Research and development costs 4,048 203,800 47,500 20,400 6.760 29,500 15,100 11,300 338,408 -6,518 0 Cashflow from financing activities Change in short-term debt Change in long-term debt Change in investments 100,000 0 100,000 Cash flow from investment activities Investment in property Investment in equipment Investment in plants Change in cash 93,482 Income statement 5 Net turnover Cost of sales Gross sales margin 333,865 150,743 183,122 70,500 49,958 120,458 62,664 0 0 0 20,400 -20,400 Sales costs General administration costs Sum of costs Operating profit Other company revenues Other company costs Interest revenue Interest costs Net financing costs / income Operational earnings before taxes Taxes over operational earnings Operational earnings Exceptional losses and profits Taxes over exceptional result Exceptional result after taxes Net profit 42,264 0 42,264 0 0 42,264 5 2,500 0 0 3,750 6,250 33,336 6,664 0 1,000 20,000 9,500 70,500 6,251 Depreciation on property Depreciation on equipment Depreciation on plant Depreciation on distribution channels Depreciation Remuneration for salesstaff Social security and national insurance contributions salesstaff Other sales costs Depreciation costs on sales department Marketing costs Market research Sales costs Remuneration for general departments Social security and national insurance contributions general departments Other general costs Depreciation on general departments Bad debts and provisions Product research and development Production volume variance Quality costs Cost for warehousing General administration costs Cost of products Cost of sales Change in inventory ready for sale 1,250 15,100 5,250 0 11,300 0 6,760 4,048 49,958 203,800 150,743 53,057 Sales & Inventory Sales results period 5 Below you will see the sales results of this period. The amount supplied is the amount of ordered products in the previous period plus the number of unsold products from the previous periods. The products ordered in the current round cannot be sold in the same round. They will be delivered in the next round and can thus only be supplied for sale at such time. 278 0 0 452 452 0 681 Demand Supply Sales Unsold inventory Smart watches 410 278 Luxury watches 461 255 255 Modern watches 560 Sports watches 57 57 624 1,488 1,666 1,042 624 Current inventory (including purchases period 5) Products ordered in the previous period are added to your inventory. Below you will see your current inventory which should be sold in this round using your current decision possibilities. Be aware: The warehousing costs of the stock are $2 per product for period 5. Sports Watches Year 1 Amount 15 500 2 Cost of sales $144.00 $144.00 $148.00 $148.00 Supplier Henderson Ltd. Henderson Ltd. Schneider GmbH Schneider GmbH 3 100 9 Smart watches Amount Year 5 Luxury watches Cost of sales $148.00 Supplier Schneider GmbH 280 Year 5 Modern watches Amount 520 Cost of sales $153.00 Supplier Schneider GmbH Year Cost of sales Amount 600 Supplier Schneider GmbH 5 $138.00 Supplier choice Warning: The products ordered now are available in period 6. Choose your supplier(s) by analysing the five criteria below. Prodovski S.A. Hongkong Ltd. Kansas Inc. Henderson Ltd. Schneider GmbH Cost Quality Dependability Flexibility Speed The prices are excluding the variable transport costs of 8 per unit. The current method of transportation is buy from regional center and can be altered at the decisions for Distribution Smart watches Luxury watches Modern watches Sports Watches Amount 280 600 0 Supplier Schneider GmbH Schneider GmbH Schneider GmbH Schneider GmbH Supplier lists 520 Prodovski S.A. Hongkong Ltd. Kansas Inc. Henderson Lid. Schneider GmbH Smart Watches $100.00 $110.00 $120.00 $130.00 $140.00 Luxury watches $106.00 $115.00 $125.00 $135.00 $145.00 Modem watches $80.00 $100.00 $115.00 $125.00 $130.00 Sports Watches $120.00 $122.00 $128.00 $130.00 $140.00 Marketing Decide the selling prices and marketing budgets for your products, Smart Watches Luxury watches Amount to sell 255 Price 320 335 278 Modern watches 452 315 Sports Watches 681 300 Marketing communcation Decide how to approach your (potential customers Budget 5000 6000 5000 4000 Communication mix Direct marketing Commercial Personal sales Commercial Message Price/quality Best quality Rich history Society E-commerce Mobile advertismery Mobile advertismei Mobile advertisme Mobile advertisme Quality check Decide if you would like to do an extra quality check on your products. Product fallures can cause serious damage to your image. Below you will find the costs per article for each quality check No check Basic check Sufficient check Full check Cost per article 0 Basic check Sufficient check Full check Basic check Supplier Confirm Balance sheet 2 Fixed assets Property 47,500 51,250 47,500 51,250 Fixed financial assets Investments 288,000 Current assets Inventory Accounts receivable Cash 341,230 63.203 72,586 0 149,900 477,019 524,519 437,900 489,150 Total assets Short-term liabilities Accounts payable Current account 0 0 0 Long-term liabilities Bank loan (long term) 200,000 200,000 Group equity Total liabilities and Group equity 200,000 324,519 524,519 200,000 289,150 489,150 Balance sheet 3 2 Fixed assets Property $53.750 $47,500 $53,750 $47,500 Fixed financial assets Investments $0 $0 $0 $ SO $260,205 Current assets Inventory Accounts receivable Cash $60,303 $418,486 $341,230 $63,203 $72,586 $738,994 $792,744 $477,019 $524,519 Total assets Short-term liabilities Accounts payable Current account $0 SO $0 SO $0 $0 Long-term liabilities Bank loan (long term) $400,000 $200,000 Group equity Total liabilities and Group equity $400,000 $392,744 $792,744 $200,000 $324,519 $524,519 Balance sheet 3 2 Fixed assets Property $53,750 $47,500 $53,750 $47,500 Fixed financial assets Investments $0 50 $0 Current assets Inventory Accounts receivable Cash $260,205 $60,303 $418,486 $341,230 $63,203 $72,586 $477,019 $738,994 $792,744 Total assets $524,519 Short-term liabilities Accounts payable Current account $0 SO $0 $0 $0 SO Long-term liabilities Bank loan (long term) $400,000 $200,000 $200,000 $400,000 $392,744 $324,519 Group equity Total liabilities and Group equity $792,744 $524,519