Question

Pro Forma Income Statement Homer Simpson's Bike Store (HSBS) in downtown Charleston had a sales revenue of $1,000,000 in the year of 2019. The cost of goods sold in 2019 was $500,000. In addition, HSBS paid a total of $200,000 for staff salaries and $100,000 for administrative overhead. It also spent $50,000 on advertising and sales promotion in 2019. In the year of 2020, Homer Simpson expects sales to grow by 15 percent. The cost of goods sold is also expected to increase by 10 percent. In addition, it is also expected that the staff salaries and administrative overhead will increase by 5 percent in 2020. Due to increasing competition in downtown Charleston, HSBS also intends to spend 30% more on advertising and sales promotion in 2020 than in 2019. Based on the information above, please prepare a pro forma income statement for Homer Simpson's Bike Store in the year of 2020. Pro Forma Income Statement 2020 Sales Cost of goods sold Gross margin I Marketing expenses General and administrative expenses Staff salaries Administrative overhead Net profit before income tax
please show work

Answer 1

Year 2019
Sales	10,00,000.00
COGS	5,00,000.00
%	50.00%
Staff Salaries	2,00,000.00
Admin Overhead	1,00,000.00
Advertising and Sales Promotion	50,000.00
Year 2020 Statement
Sales (1.15 * 10,00,000)	11,50,000.00
Cost of Goods sold
As per2019 (50% of Sales, 5,75,000)
Increased by 10%
So, COGS (1.1 * 5,75,000)	6,32,500.00
Gross Margin	5,17,500.00
Marketing Expenses	65,000.00
(1.3 * 50,000)
General and admin exp
Staff Salaries	2,10,000.00
(1.05 * 2,00,000)
Admin Overhead	1,05,000.00
(1.05 * 1,00,000)
Net Profit before income tax	1,37,500.00