Answered step by step
Verified Expert Solution
Question
1 Approved Answer
You have an internship at The Bike Store. The Chief Financial Officer needs your help to prepare the 2021 Budget which YOU will present to
You have an internship at The Bike Store. The Chief Financial Officer needs your help to prepare the 2021 Budget which YOU will present to the Board of Directors Meeting at their meeting next week.
Your task is to create the 2021 Budget in an Excel Spreadsheet. You only need to prepare an Income Statement
Assume:
- The company will sell 16,000 bicycles at an average price of $2,500 each
- Cost of Labor is 20% of Sales
- Cost of Materials is 10% of Sales
- Variable Overhead is 6% of Sales
- Fixed Manufacturing Overhead is $4,000,000
- Office Salaries are 5,000,000
- Office Deprecation Expense is $500,000
- Lease Expense of Corporate Office is $2,000,000
- Advertising is $1,000,000
- Income Taxes are 30% of all revenues minus all expenses before income taxes.
The Board of Directors will also want to know, with the assumptions above what would be the company:
- Gross Profit Margin?
- Operating Profit Margin?
- Net Profit Margin?
- Number of bicycles to sell to breakeven? Assume if the company is breakeven, income taxes will be zero.
Since this is an internal report, you dont necessarily have to use a GAAP Income Statement
Make sure the report is easy to follow
After you have finished Step 1, below is what your report should read. Item Correct Figure 1 - Net Income $9,170,000 2 - Gross Profit Margin 54.00% 32.75% 3 - Operating Profit Margin 4 - Net Profit Margin 22.93% 5 - Number of bicycles to sell to breakeven? 7,813 (rounded up)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started