{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

RES7-22 - 3518 6026 4023 0 13979 1 FINANCESIM QUART ER 22...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
806f8c22e77bfd651818fd1eb90b7233a6d0a9d9.xls 1/1 03/13/2014 QUARTER 22 FINANCESIM FIRM 7 Forecasts and decisions at the Beginning of the Quarter Forecasts Prod-A Prod-B Prod-C Firm Sales (units) NA NA NA Cash balance at end of Quarter ($) 50,075 After tax profits ($) 75,571 Marketing decisions Sales Price ($/unit) 16.27 24.41 19.32 Discount for prompt payment (%) 0% 0% 0% Promotional expenditures ($) 3,000 5,000 4,000 Competitive information (0,1) 0 0 0 Production decisions Supplier (1,2) 1 1 1 Production orders (units) 7,545 10,438 16,108 Purchase of equipment (production units) Sale of equipment (quarter acquired) Finance Decisions Loan requests 90-day 1-year 5-year Amount ($) Purchase of Certificate of Deposit (CD) 90-day 180-day 270-day Amount ($) 165,533 Advance payment (1-Year loans) Transact.1 Transact.2 Transact.3 Amount ($) Quarter maturing Advanced payment (5 -Year loans) Amount ($) Quarter maturing Sale of Certificate of Deposit 180-day 270-day 270-day Amount ($) 0 0 0 Quarter maturing 0 0 0 Bonds issuance ($) Bonds recall Transact.1 Transact.2 Transact.3 Amount ($) Quarter maturing Stock issuance ($) Stock repurchase ($) Dividends ($) FALSE SALES AND FORECAST ERRORS REPORT Market Sales Prod-A Prod-B Prod-C Units 113,175 156,570 241,620 Average Price ($) 16.27 24.41 19.32 Average Promotional Expenses 3,000 5,000 4,000 Firm sales Potential (units) 7,545 10,438 16,108 Actual (units) 7,545 10,438 16,108 Market share (%) 6.67% 6.67% 6.67% Sales for Cash Price ($) 0.00 0.00 0.00 Volume (units) 0 0 0 Value ($) 0 0 0 Sales on credit Price ($) 16.27 24.41 19.32 Volume (units.) 7,545 10,438 16,108 Value ($) 122,757 254,792 311,207 688,755 Total Price ($) 16.27 24.41 19.32 Volume (units) 7,545 10,438 16,108 Value ($) 122,757 254,792 311,207 688,755 % 17.8% 37.0% 45.2% 100% Forecast errors Sales Forecasted (units) NA NA NA Actual (units) 7,545 10,438 16,108 Forecast error (%) NA NA NA Cash Balance Required ($) 50,075 Actual (planned transactions) ($) 50,075 Forecast error (%) 0.35% Net income Forecasted ($) 75,571 Actual ($) 75,571 Forecast error (%) 0.00% INCOME STATEMENT ($) 1. Sales 688,755 2. less cost of goods sold 532,284 3. Gross profit 156,472 4. less marketing expenses 12,000 5. less administrative expenses 23,663 6. Operating income 120,809 7. less financial cost 6,105 8. plus financial income 1,559 9. gain (loss) in Sale of Fixed Assets 0 10. Income before taxes 116,262 11. less income tax 40,692 12. Net income 75,571 BALANCE SHEET ($) ASSETS 1. Cash 50,075 2. Accounts receivable 688,755 3. Interest receivable 1,559 4. Short-term investments 165,533 5. Finished goods inventory 0 Total current assets 905,922 6. Main Equipment (less accumulated depreciation) 919,072 7. Other equip. buildings and land (less accum.depreciation) 414,894 8. Prepaid fixed assets 0 Total fixed assets 1,333,966 9. Total assets 2,239,888 LIABILITIES 10. Taxes payable 40,692 11. Interest payable 6,105 12. Accounts payable 0 13. Short-term loans 0 14. Long-term loans due in in the short run 0 15. Bonds due in the short run 220,000
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}