Develps and markets productivity software

Assignment Help Financial Management

Reference no: EM131053100

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.

Reference no: EM131053100

Questions Cloud

The day he retires to realize his retirement dream : Mark freeda wants to plan for retirement and needs your advice. in the first 5 years of his retirement he plans to travel and will need 450,000 each yr to do so. after that he will be able to live on 100,000 per yr. mark does not know how long he wil..

Company that focus on assisting effective decision making : Youth commitment and youth voice: Young people have significant roles in the family, school, and the community, where their assistances make a difference. These aids can include service, asking with adults in the organization, and collective leade..

Types of loans requires periodic repayments : Which one of the following types of loans requires periodic repayments, each of which reduces the principal balance?

Regarding the benefits of a pro-active approach : 3) Provide some advice relating to this general topic of obesity that you might give yourself or others regarding the benefits of a pro-active approach to a healthy lifestyle.

Develps and markets productivity software : 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 p..

Refer to the real world case on social networks : Refer to the Real World Case on social networks, mobile commerce, and online shopping in the chapter. Do you think that mobile devices (not just phones anymore) are becoming the major platform for shopping, communication, everything? What are the ..

Assets-liabilities-equity-dividends-revenues and expenses : Use the following information to prepare a trial balance. (Leave no cells blank - be certain to enter "0" wherever required. The items in the Trial Balance should be grouped as follows: Assets, Liabilities, Equity, Dividends, Revenues, and Expenses.

Use of new health information technology : The HITECH provision of ARRA will facilitate the use of new health information technology in a range of health care organizations, from hospitals to physicians' practices. To encourage a timely transition, HITECH includes incentives for providers ..

How well written and persuasive is the plan : I will look at your Network Design Plan from the point of view of a business proposal or Response for Proposal or Quote. Have you thought through and considered your options? Have you provided details of your proposal? Have you looked at the entir..

User Account

All Pages