Question: This project is about preparing a pro forma income statement for a newly opened private bookstore. This bookstore expects sales of $1,500,000 in the first
This project is about preparing a pro forma income statement for a newly opened private bookstore. This bookstore expects sales of $1,500,000 in the first year (2023), with a set of sales growth rates (SGR) values to be tried out. This bookstore estimates the following percentages of total sales for various costs and expenses: Costs & Expense Cost of Goods Sold Salary & benefits Advertising General, selling, & administration Miscellaneous expenses Percent of Sales 60.0% 26.0% 2.5% 4.8% 2.1% The Rent & Utility expense is $40,000 for the first year (2023, and grows at a different rate for each year as determined by the following formula: 6.5%+ 0.2%*(number of years away from the base year)12. Taxes are paid only when the Earnings Before Taxes is non-negative. ASSIGNMENTS: Conduct one variable data table analysis for Net Profit After Taxes (NPAT) for 2025 by varying SGR on the following set of rates: 15.0%, 16.0%, 17.0%, 18.0%, 19.0%, 20.0% Q1. Find the SGR value which yields the highest N. Let the above value be the value for SGR in this question. In this second question, we conduct two-variable data table analysis by varying Salary & Benefits on the set of rates: 25.0%, 26.0%, 27.0%, 28.0%, 29.0%, 30.0%; and varying Advertising on the set: 2.5%, 3.0%, 3.5%, 4.0%. Altogether there are 24 combinations. Q2. Identify which combination of values yields the highest value of NPAT. Q3. Show the Pro Forma income statement based on the SGR.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
