Question
Help Requirements: Using Microsoft Excel to create pro-forma income statement based on the following assumptions Sales for first month: $60000 Cost of sales = 42%
Help
Requirements: Using Microsoft Excel to create pro-forma income statement based on the following assumptions
Sales for first month: $60000
Cost of sales = 42% of sales, all variable
Operating expenses = $10,000 fixed plus 5% of sales
Tax rate 30%
Sales increased by 5% each moth
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
Intellectual Property Law
Authors: Tina Hart, Simon Clark, Linda Fazzani
6th Edition
0230366538, 978-0230366534
