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
806f8c2 e7 bfd651818fd1eb90b723 a6d0a9d9.xls 1/1 03/13/2014 QUARTER 2 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,0 0 5,0 0 4,0 0 Competitive information (0,1) 0 0 0 Production decisions Sup lier (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,53 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 is uance ($) Bonds recal Transact.1 Transact.2 Transact.3 Amount ($) Quarter maturing Stock is uance ($) Stock repurchase ($) Dividends ($) FALSE SALES AND FORECAST ERRORS REPORT Market Sales Prod-A Prod-B Prod-C Units 1 3,175 156,570 241,620 Average Price ($) 16.27 24.41 19.32 Average Promotional Expenses 3,0 0 5,0 0 4,0 0 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.0 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 ($) 12 ,757 254,792 31 ,207 68 ,75 Total Price ($) 16.27 24.41 19.32 Volume (units) 7,545 10,438 16,108 Value ($) 12 ,757 254,792 31 ,207 68 ,75 % 17.8% 37.0% 45.2% 10 % Forecast er ors Sales Forecasted (units) NA NA NA Actual (units) 7,545 10,438 16,108 Forecast er or (%) NA NA NA Cash Balance Required ($) 50,075 Actual (plan ed transactions) ($) 50,075 Forecast er or (%) 0.35% Net income Forecasted ($) 75,571 Actual ($) 75,571 Forecast er or (%) 0.0 % INCOME STATEMENT ($) 1. Sales 68 ,75 2. les cost of go ds sold 532,284 3. Gros profit 156,472 4. les marketing expenses 12,0 0 5. les administrative expenses 23,6 3 6. Operating income 120,809 7. les financial cost 6,105 8. plus financial income 1,5 9 9. gain (los ) in Sale of Fixed As ets 0 10. Income before taxes 1 6,262 1 . les income tax 40,692 12. Net income 75,571 BALANCE SHEET ($) AS ETS 1. Cash 50,075 2. Ac ounts receivable 68 ,75 3. Interest receivable 1,5 9 4. Short-term investments 165,53 5. Finished go ds inventory 0 Total cur ent as ets 905,92 6. Main Equipment (les ac umulated depreciation) 919,072 7. Other equip. buildings and land (les ac um.depreciation) 414,894 8. Prepaid fixed as ets 0 Total fixed as ets 1,3 3,96 9. Total as ets 2,239,8 8 LIABILITIES 10. Taxes payable 40,692 1 . Interest payable 6,105 12. Ac ounts 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 2 0,0 0 Total cur ent liabilities 26 ,797 16. Long-term loans
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

Ask a homework question - tutors are online