Master tech is a new software company that develps and


Master Tech is a new software company that develps and markets productivity software for municipal government applications. In developing their income statement, the following fomulas are used: Gross profit = Net sales - Cost of sales Net operating profit = Gross profit - Admnistrative 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 expneses 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.

Request for Solution File

Ask an Expert for Answer!!
Financial Management: Master tech is a new software company that develps and
Reference No:- TGS01398954

Expected delivery within 24 Hours