Develop spreadsheet model to calculate the net income

Assignment Help Financial Management
Reference no: EM131313189

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 $1,250,000. Costs of sales is estimated to be $300,000. Selling expenses have a fixed component that is estimated to be $90,000 and a variable component that is estimated to be 8% of net sales. Administrative expenses are $50,000. Interest expenses $8,000. The company is taxed at a 50% rate. Develop a spreadsheet model to calculate the net income. Design your spreadsheet using good spreadsheeet-engineering principles.

Reference no: EM131313189

Questions Cloud

Types of stakeholders : Visit the Monsanto website to find information that is directed at 3 types of stakeholders: investors, employees, and customers. Describe the different types of information found and how it may be perceived by these different stakeholder groups.
Brewers of samuel adams boston lager : Conduct a strategic analysis using the Executive Summary template.  Prepare and submit a two page executive summary that discusses what strategic alternatives are available and provide a recommended strategy.
What is a depreciation tax shield : If a project does not affect a company's revenues, but reduces its costs, how can this affect the value of the company?
How different concepts affect each other : Compare the nursing philosophy of Benner and Henderson on the basis of the following criteria.Main ideas of the theory,Main concepts,Relationships between concepts,How different concepts affect each other.
Develop spreadsheet model to calculate the net income : MAsterTech is a new software company that develops and markets productivity software for municipal government applications. Administrative expenses are $50,000. Interest expenses $8,000. The company is taxed at a 50% rate. Develop a spreadsheet model..
Characteristics-responsibilities of at least four potential : Create a Mind Map or infographic that defines at least 7 to 10 characteristics and responsibilities of at least four potential roles of human resources representatives within an organization.
Does it pay back in terms of discounted cash flows : If a company sells an asset for less than its original cost, but more than its book value, how is that gain classified and taxed?
Benefits of developing a team charter : What would be the benefits of developing a team charter as part of a group project in this class or another class you are taking?
Determine the standard deviation of the expected return : Following are three economic states, their likelihoods, and the potential returns: Determine the standard deviation of the expected return.

Reviews

Write a Review

Financial Management Questions & Answers

  Profitability-liquidity-leverage and activity ratios

Include profitability, liquidity, leverage, and activity ratios for which you have data available (data may not be available for all ratios - just use what's available in the case). Present your calculations in table format.

  Fraud in the inducement

Nymeria buys a promissory note off of Yolanda for $300. Nymeria buys the note in good faith, and she is unaware of the fact that Yolanda secured the note from Georgia through Fraud in the Inducement. Nymeria seeks to enforce the note. Can she?

  Annual cash flows-indifferent in accepting project-rejecting

A project that provides annual cash flows of $12,300 for 9 years costs $70,836 today. If the required return is 3 percent, the NPV for the project is $ _________ and you would accept the project. At a discount rate of _________ percent, you would be ..

  About the credit terms

Credit terms. Purchases made on credit are due in full by the end of the billing period. Many firms extend a discount for payment made in the first part of the billing period.

  Running retirement community

Mary is running a retirement community and is negotiating with a client, Jimmy, who wishes to reside at Mary’s community when he retires in ten years at age 65. Actuarial statistics indicate that Jimmy will probably die at age 85. Calculate the prese..

  Using the free cash flow valuation model to price

Using the free cash flow valuation model to price an IPO Assume that you have an opportunity to buy the stock of CoolTech, Inc., an IPO being offered for $12.50 per share. Although you are very much interested in owning the company, Use the free cash..

  Interest rate parity-forward exchange rate

The nominal yield on 6-month T-bills is 7%, while default-free Japanese bonds that mature in 6 months have a nominal rate of 4.5%. In the spot exchange market, 1 yen equals $0.008. If interest rate parity holds, what is the 6-month forward exchange r..

  What is the payback period for the investment project

Superlink Inc. is considering an investment that has the following cash flows: What is the payback period for the investment project? What is the project's NPV if the firm's cost of capital is 12%?

  The maintenance cost on a machine is expected

The maintenance cost on a machine is expected to be $5,000 during the first year, $6,000 during the second year, and to increase $500 each year for the following 9 years. What present sum of money should be set aside now to pay for the required maint..

  Using the step-down method to allocate costs

St. Payne Med Center is using the step-down method to allocate costs. They have two support departments (Record Keeping and Cleaning), and two patient service departments (Eye Care and Dental Care). Some of the Record Keeping costs are allocated to C..

  Assume semi-annual compounding-semi-annual coupon payments

You can buy or sell a 3.5% $1000 par U.S. Treasury Note that matures in exactly 6 years (meaning it pays (.035/2)*1000 coupon payments every 6 months, starting 6 months from now through maturity, and repays principal on maturity), with a current yiel..

  How many years will it take to reach your goal

Number of Periods of an Annuity You have $42,149.51 in a brokerage account, and you plan to deposit an additional $5,500 at the end of every future year until your account totals $250,000. You expect to earn 10.7% annually on the account. How many ye..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd