Calculate the net income, Develop a spreadsheet model to

Calculate the net income

Reference no: EM13817550

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.

Reference no: EM13817550

Questions Cloud

Critical thinking - philosophy : Critical Thinking - Philosophy

Gluten free cheerios and a marketing plan : Write a 1,000 word paper that includes the following: Your promotional strategy for General Mills and Gluten Free Cheerios and a Marketing Plan

Calculate the total costs of delivering style : Calculate how many style A, B, and C shades can be loaded into an intermodal container. Calculate the total costs of delivering style A, B, and C shades to the port of importation

Explain why gasoline will not dissolve in water : Explain why gasoline will not dissolve in water

Calculate the net income : Develop a spreadsheet model to calculate the net income. Design your spreadsheet using good spreadsheet engineering principles.

Question regarding the managerial accounting : 1. In 3 to 4 paragraphs explain what Managerial Accounting is? 2. In 3 to 4 paragraphs explain why managerial accounting matters to your career?

Problem related to revenue expenditures-capital expenditures : Write a 350- to 700-word summary explaining the differences between revenue expenditures and capital expenditures during a useful life and identifying any similarities. Briefly explain the entries of revenue expenditures and capital expenditures.

Discuss the role of wisdom in true virtue according to meno : Discuss Plato's arguments for recollection in the Meno; what puzzle is recollection supposed to solve? Discuss the role of wisdom in true virtue according to Meno and the Phaedo.

Explain how to create a presentation : As an example, runoff from a coalmine may be contaminating the groundwater of a nearby town. A solution to abating the contaminated groundwater could be to shut down the coalmine, but at the cost of everyone losing their jobs.

User Account

All Pages