how do you put this in excel?
MasterTech is a new software company that develops and markets productivity software for municipal government applications. In developing their income statement, the following formulas are used:
Gross profit = Net sales - Cost of sales
Net operating profit = Gross profit - Administrative expenses - selling expenses
Net income before taxes = Net operating profit - interest expense
Net income - Net income before taxes - taxes
*Net sales are expected to be $900,000. Cost of Sales is estimated to be $540,000. Selling expenses has a fixed component that is estimated to be $90,000, and a variable component that is estimated to be 7% of net sales. Administrative expenses are $50,000. Interest expenses are $10,000. The company is taxed at 50% rate. Develop a spreadsheet model to calculate the net income. Design your spreadsheet using good spreadsheet engineering principles.
11 years ago 3
- GHA 5 principles of marketing
- PHI 445 Week 1 Quiz ~ ( Latest Syllabus - Updated Feb, 2015 - Perfect Tutorial - Scored 100% )
- Discussion board postings.
- Organizational Structure Paper
- MGMT 340 Week 2 Quiz................(MGMT 340 Business Systems Analysis - DeVry)
- 2-3 pages essay
- HIS204 Week 5- Discussion 2 FOR SUZIKANE8 ONLY!!!!!
- Module 5: Critical Thinking
- ETH 125 Week 4 DQ2
- three