Before tax and after tax cash flows

Assignment Help Basic Computer Science
Reference no: EM131220323

For this week's assignment, update the spreadsheets you created in Modules 3 to incorporate depreciation and taxes. This will require you to consider and model before tax cash flows and after tax cash flows in your models and then determine the appropriate output for your model. Assume straight line depreciation only. A simple example is in Chapter 12. 

Inputs from the user would include initial investment, marginal tax rate, useful life, salvage value, MARR, annual benefits (revenue), and annual costs.

The inputs for your submission are:

Initial Cost

$100,000

Annual Revenues

$81,155

Annual Costs (Excluding Depreciation)

$20,000

Year 3 Overhaul

$15,390

Year 6 Clean-up Costs

$17,690

Equipment Salvage/Book Value

$10,000

Useful Life

6 years

r (this was not provided in 2.3)

0.10

Tax Rate

0.35

Equipment Sold For

$20,000

Your model should show the before tax and after tax cash flows as well as the PV of the AFTC in each year and of course the NPV, which is the final solution. Your submission should include the model in ready to use clean version and a completed model using the above information (on separate tabs).

Reference no: EM131220323

Questions Cloud

What are major wetlands of china : What are major wetlands of China? Where are they located? In general, how do they differ form wetlands of United States? Although many attempts have been made, there is still no universally accepted definitions for wetlands. Why is it so? How   do po..
Consumer preferences over goods : Suppose a consumer's preferences over goods 1 and 2 are represented by the utility function U(x1, x2) = (x1 + x2)^3. Draw an indifference curve for this consumer and indicate its slope.
Vertical axis and lattes on the horizontal axis : Draw his budget line with burritos on the vertical axis and lattes on the horizontal axis. Make sure to carefully label your graph and all the relevant points.
Compensated based on both net income and cash flows : You work at Delhaize. Your boss is compensated based on both Net Income and Cash Flows and wants to know the effect (direction and amount) that each of the following transactions would have on 2015 Net Income and 2015 Cash Flows. Delhaize signs a con..
Before tax and after tax cash flows : Your model should show the before tax and after tax cash flows as well as the PV of the AFTC in each year and of course the NPV, which is the final solution. Your submission should include the model in ready to use clean version and a completed mo..
Find corresponding current and find interval : The charge entering a certain circuit element is found to be q=5te-10tc. - find corresponding current and find interval t less then 0 at which current is minimum?
Add the geometric dimensioning information : Where the small cylinder intersects the large cylinder in the right side view, make the face on the larger cylinder datum feature D. Control this surface with a fl atness tolerance of .005.
When actual gdp is above natural real gdp : When actual GDP is above natural real GDP, is the value of actual unemployment rate above, below, or equal to the natural unemployment rate?
Currently in place in united states : What rate of income tax from all level of government is currently in place in United States?

Reviews

Write a Review

 

Basic Computer Science Questions & Answers

  Nist criteria for selection of des and aes relate to shannon

How do the NIST criteria for selection of DES and AES relate to Shannon's original standards of a good cryptographic system?

  Unspecified number of scores

Write a program that reads an unspecified number of scores and determines how many score are above or equal to the average and how many scores are below average. Enter a negative number to signify the end of the input. use c++ to write the program..

  Manages the deletion of users

To do some basic administration work using common tools and configure/ install a package-Write down the command you would enter to create a account for the staff member Steven Jobs. The user should have a home directory in /homeand should belong to..

  Displaying all n integers in a sorted linked chain

Displaying all n integers in a sorted linked chain

  Difference between persistent and transient objects

How is persistence handled in typical OO database systems?

  Recommend two 2 factors which would affect the decision to

suggest two 2 factors that would influence the decision to disable bridge all site links as part of the site

  Advantage and disadvantage of using word to work in graphics

Identify the advantages and disadvantages of using Word to work with graphics, tables, and special formatting functionality. Provide specific examples.

  Find out how smtp hosts deal with unknown commands

You can either read the RFC or contact an SMTP server as in Exercise 14 and test its responses to nonexistent commands.

  How cost of box is evaluated in lookup table

Cost of box is determined by looking up value in a lookup table. Shipping cost also is determined by looking up value in a lookup table. Use table at cells H23:J28 with a VLOOKUP function to determine cost of a box.

  Potential business owner in the hoomaflopper industry

Decision Analysis Problem: You are a potential business owner in the hoomaflopper industry. You have hired Dustin R. Mopps as your industry insider to help you decide which businesses to focus on potentially buying.

  What aspects of nelson''s xanadu resemble the web

Search the Web for illustrations of the proposed Memex I or Memex II and compare the sketches to modern computer devices

  Salaries and proposed wage increases of your coworkers.

1. Take a position on whether or not you believe most employees abide by their organization's AUP. Support your position with an explanation. Propose ways that an organization can enforce this policy. 2. Suppose your department manager accidentally s..

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