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

  Application letter and resume

In this project, you will work with a fax cover sheet, an application letter, and a resume. To complete the project you will create a table, add text to a table, and format tables.

  Depreciation allowance percentages

What is the operating cash flow for year 3 given the following sales amounts and MACRS depreciation allowance percentages?

  Total number of infected computers

a) How many computers will be infected during the 6th interval? b) What will be the total number of infected computers after 3 minutes?

  Debtors an unlimited exemption on homes

Some states permit debtors an unlimited exemption on their homes. Is it fair for bankrupts to be allowed to keep multi-million dollar homes, while their creditors remain unpaid? But other states allow as little as $5,000. Should bankrupts be throw..

  Implement some form of raid

You've been hired by a company that wants to expand and improve storage on their servers. They would like to implement some form of RAID, but are unclear what the different options provide.

  Based on the database schema

Based on the database schema:     Movies(movieTitle, year, length, genre,studioName,producerCertificateNum) StarsIn(movieTitle,movieYear,starName)

  How does this complicate the job of dns

How does this complicate the job of DNS? How does this affect the problem of finding your local DNS server?

  How computer tackles loss of power to limit loss

In short talk about how computer tackles loss of power to limit loss of all work that has been done. In discussion, you may wish to consider concepts like: multiprogramming, time-sharing, time-slice, and interrupts.

  The availability and multitude of forensic toolkits

the availability and multitude of forensic toolkits continue to increase. the last decade has witnessed the emergence

  Types of analysis that star schema

1. The star schema shown in the scenario above describes part of the database that will provide decision-support for a property sales company. Describe the main characteristics of fact and dimension tables, and discuss the purpose of the tables sh..

  Force p to prevent the 30-kg rod ab from sliding

Determine the minimum force P to prevent the 30-kg rod AB from sliding. The contact surface at B is smooth, whereas the coefficient of static friction between the rod and the wall at A is µs = 0.2

  Describe basic elements of embedded control system

Describe the basic elements and operation of the chosen embedded control system - Examine the robust control methods which could be used for increasing the performance and energy efficiency of the chosen embedded control system.

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