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

  Market price on the expiration date

You borrowed the money for the premium at 5% continuous compounding rate. If the euro's market price on the expiration date (t = 3/12) is $1.21, how much is your net profit/loss per unit indollars and in euros?

  Controlling and providing support for all essential function

The motherboard is the central part of a PC, controlling and providing support for all essential functions. Search the Internet for one website on either Motherboard manufacturers or a website that provides technical reviews of motherboards. Share..

  Maintain inventory data on resources stored in the library

Provide an eLibrary system where patrons can search a database to retrieve either the location of an actual resource in the library or an electronic copy of the source.

  Diseases of the gastrointestinal system

A new appreciation for the path the food you eat takes. Let's examine some of the problems that patients encounter in this complex body system. A section titled "A Quick Trip Through Some of the Diseases of the Gastrointestinal System".

  Write a program in python shell

Write a program in python shell. Convert inches into yards, feet, and inches. This time, use a variable to store the number of inches. You may use more than one variable.

  What is the goal of encryption

What is the goal of encryption?

  Find a video on how wireless attacks are conducted

Find a video on how wireless attacks are conducted. Summarize the video in your own words, and discuss why an investigator should care about this information. Include the link to the video.

  Application for a small catering business

For this assignment, you are required to design and develop a console (text-based) application for a small catering business. This application will simulate booking appointments, tracking catering jobs and processing payments.

  Case study-database development

Note: The ACM Digital Library is a Strayer Library database located in iCampus > Campus & Library > Learning Resource Center > Databases.

  Replace that definition with a recursive one

Replace that definition with a recursive one, and show that it is O( n ).

  Describing the tool used in linux to schedule tasks

Many system maintenance tasks should be performed at regularly scheduled times. In Linux, it is possible to automate these tasks. For this assignment, write a 2-4 page essay describing the tool used in Linux to schedule these tasks. As part of your d..

  How many register window should be saved to memory as result

Assume two more calls are made after the maximum value from part (a) is reached. How many register windows must be saved to memory as a result?

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