Week 11 - MKTG 4890 Week 11 Marketing Budget D. FINANCIAL...

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

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: MKTG 4890 Week 11 Marketing Budget D. FINANCIAL STATEMENTS Marketing Budget 1. Product Cost (use 1/3 of your selling price) selling 2. Selling expense 2. 3. Promotion expense 4. Advertising Pro Forma Annual and 5-Year Profit and Loss Statement and Pro Forma Financials(year1) $K Q1 Q2 Q3 Q4 Total Sales 100 150 67.5 82.5 200 90 110 550 1000 Less Cost of 45 Less Goods Sold Goods Margin 55 247.5 450 307.5 550 Less: Marketing Expenses $K Personal Personal Selling Sales Sales Promotion Promotion Advertising Advertising Net Profit 25 25 15 10 10 5 25 0 5.5 52 25 0 0 85 25 25 4.5 248 100 40 20 390 Pro Forma Financials (yr1-5) K$ Years Sales of GSold of 1 1000 2 1500 675 875 3 1800 810 990 4 2000 900 1100 1100 5 2100 945 1155 1155 Total 8400 3780 4620 Less C 450 Less Gross 550 Margin Less: Marketing Expenses (K$) Personal Personal Selling Selling 100 120 150 25 5 20 5 100 20 5 895 90 15 5 640 120 40 Sales 40 Sales Promotion Promotion Advertising 20 Net Profit 390 675 815 1045 3820 Pro Forma Financials(year1) $K Q1 Sales Gross Margin 100 55 Q2 150 67.5 82.5 25 0 5.5 52 Q3 200 90 110 25 0 0 85 Q4 550 247.5 307.5 25 25 4.5 248 Total 1000 450 550 100 40 20 390 Less Cost of GS 45 Less Marketing Expenses Personal Selling 25 Sales Promotion 15 Advertising Net Profit 10 5 Pro Forma Financials(year1) $K Q1 Sales Margin 100 55 Q2 150 67.5 82.5 25 0 5.5 52 Q3 200 90 110 25 0 0 85 Q4 550 247.5 307.5 25 25 4.5 248 Total 1000 450 550 100 40 20 390 Less Cost of GS 45 Less Marketing Expenses Personal Selling 25 Sales Promotion 15 Advertising Net Profit 10 5 Pro Forma Financials (yr1-5) K$ Years Sales Less Cost of GS Gross Margin 1 1000 450 550 2 1500 675 875 3 1800 810 990 4 2000 900 1100 5 2100 945 1155 Total 8400 3780 4620 Less Marketing Expenses Personal Selling 100 120 150 100 90 640 Sales Promotion 40 25 20 20 15 120 Advertising 20 5 5 5 5 40 Net Profit 390 675 815 895 1045 3820 ...
View Full Document

Ask a homework question - tutors are online