MasterTech is a new software company that develops and markets productivity software for municipal government applications. In developing their income statements, the following formulas are used:

gross profits= net sales – cost of sales

net operating profits=gross profit – administrative expenses – selling expenses

Save your time - order a paper!

Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlines

Order Paper Now

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 have 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 a 50% rate. Develop a spreadsheet model to calculate the net income. Design your spreadsheet using good spreadsheet-engineering principles.

 
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.