How do I create an After tax Cash Flow Analysis? Use rounded answers for subsequent calculations Net Present Value AnalysisChampion Company is considering a contract that would require an expansion of its food processing capabilities. The contract covers five years. To provide the required products, Champion would have to purchase additional equipment for $64,000. Championestimates the contract will provide annual net cash inflows (before taxes) of $26,000. For tax purposes, the equipment will be depreciated as follows:Year 1 $8.000Year 2 16,000Year 3 16.000Year 4 16.000Year 5 8.000Although salvage value is ignored in the tax depreciation calculations, Champion estimates the equipment will be sold for $8,000 after five years.Assuming a 35% income tax rate and a 10% hurdle rate, compute the net present value of this contract proposal. Using net present value analysis, should Champion accept the contract?Round answers to the nearest whole number. Use rounded answers for subsequent calculations.Use a negative sign with net present value to indicate a negative amount. Otherwise do not use negative signs with your answers.After-Tax Cash Flow AnalysisAmount Present ValueAfter-tax cash inflows for S yearsTax savings from depreciationYear 1Year 2Year 3Year 4Year 5After-tax equipment sale proceedsTotal present value of future ash flowsInvestment required in equipmentNet positive (negative) present valueShould Champion accept the contract?

Answered: How do I create an After tax Cash Flow…

Business

Accounting

How do I create an After tax Cash Flow Analysis? Use rounded answers for subsequent calculations

EBK CONTEMPORARY FINANCIAL MANAGEMENT

14th Edition

ISBN:9781337514835

Author:MOYER

Publisher:MOYER

Chapter19: Lease And Intermediate-term Financing

Section: Chapter Questions

Problem 8P

See similar textbooks

Related questions

Q: What is the maximum amount they can deduct for charitable contributions in 2021? a.$1,700 b.$2,000 c...

A: Solution:- Given, Eugene and Linda has adjusted gross income of $30,000 Cash contribution to church ...

Q: This process refers to the reporting of the information processed in the accounting system to intere...

A: Accounting system is the system used to record all the business transactions occurring during the pe...

Q: 1. The interest cost component of the net defined benefit cost is determined using a. the settlement...

A: "Since you have asked multiple question we would be solving first question,If you want any specific ...

Q: Indus clothing provides you the following ledger balances. Prepare trial balance as on 31* December,...

A: Trial balance is the summarized statement which contains debit and credit balances of various types ...

Q: Cascade Company was started on January 1, Year 1, when it acquired $165,000 cash from the owners. Du...

A: Requirement 1. Income Statement - Year 2 Particulars Amount Revenue - Cash $ 90,900 Ex...

Q: Prudential Company sold 30 air conditioning units, on January 15, 2020; sale price for each unit is ...

A: Journal Entry: Journal entry is the act of keeping records of transactions in an accounting journal....

Q: On February 1, 2020, Pat Weaver Inc. (PWI) issued 11%, $1,800,000 bonds for $2,100,000. PWI retired ...

A: Bond retirement refers to the repurchase of initially issued bonds from investors. When the bonds re...

Q: Home Office P 256,000 210,000 Branch Sales P 78,500 Purchases from outsiders 20,000 Shipments to bra...

A: Inventory : Acquired from outsiders 5,500 Acquired from home office 26,000

Q: Q13: What is Music, Inc.’s 2021 Tax Expense?

A: Tax refers to the amount that is charged by the government from the individual and organizations on ...

Q: What is the price per share (PPS) of the round and the total number of shares post-round?

A: Correct Option: C. Only (3) is correct The price per share (PPS) equals 1,280.00 €; the total numbe...

Q: In certain cases, the practitioner may issue review reports that include an Emphasis of Matter and O...

A: An emphasis of matter paragraph should be included in the review report when the practitioner feels ...

Q: Complete the Gifts to Charity section of Schedule A below to show Jerry's deduction for 2021.

A: Gifts toCharity 11 Gifts by cash or check. If you made any gift of $250 or more, ...

Q: Identify the 2 errors in the following Income Statement. Make sure to clearly explain the errors. DI...

A: Income statement is one of an important financial statement which helps investors or other stakehold...

Q: On January 2, 2021, X Co. acquired all the ordinary share of Y Co. for P2,060,000. On that date, Y C...

A: Answer Goodwill is an intangible asset that is associated with the purchase of one company by anothe...

Q: Multiple choice: 1. Which of the following statements is incorrect? A. Accounting education is the b...

A: 1. None of the statement is incorrect. 2. Accrual basis- revenue and income is realised when they ar...

Q: nary shares to acquire all of XYZ’s assets. ABC’s shares are trading at P28, and XYZ’s P10 par value...

A: Shareholder equity includes ordinary shares + Share premium + Retained Earnings

Q: Fill in the blanks with these terms: tangible asset, income statement, cash, statement of cash flow,...

A: "Since you have posted a question with multiple sub parts, we will solve first three sub parts for y...

Q: Karla Tanner opened a Web consulting business called Linkworks and completed the following transacti...

A: Answer - Journal Entry - 1) Apr. 1 Cash. $110,000 Office Equipmen...

Q: Using experts can provide high quality audit evidence in specialist situations, therefore the audito...

A: Introduction:- Auditor’s can use an expertise according to requirements other than accounting. Audi...

Q: Multiple choice: 1. This qualitative characteristic requires at least two items. A. Timeliness B. Co...

A: The answers for the multiple choice questions and relevant explanation are presented hereunder : The...

Q: Which of the following types of income is not subject to the "kiddie tax"?

A: Solution:- Kiddie Tax:- The Kiddie tax is tax on child's unearned income. "If the child's unearned i...

Q: True or false. Debit Increases in assets and expenses, decreases in liabilities and revenue?

A: The different accounts in the business have debit and credit balance. The assets and expenses have ...

Q: Plz solve it within 30-40 mins I'll give you multiple upvote

A: Bond is borrowing security issued by the company to raise funds from the market by making an agreeme...

Q: Beginning inventory last year held 2 000 rollers. The normal capacity is 29 000 units. Compute the v...

A: Variance is the difference between estimated or budgeted cost of production and actual cost of produ...

Q: beginning of the period to calculate predetermined overhead rates: Forming 7, 000 $ 25,900 $ 2.50 Cu...

A: "Since you have posted a question with multiple sub parts, we will solve first three sub parts for y...

Q: 10. On January 2, 2021, X Co. acquired all the ordinary share of Y Co. for P2,060,000. On that date,...

A: Take note that the existing Goodwill of Acquiree is written off and wont be included to your Book va...

Q: ventory on credit. ,300; the cost of th

A: The journal entry is given as,

Q: The following information came from the books and records of ABC Corporation and its branch. The bal...

A: Head office means from where the company mainly operate and all branches are controlled from that po...

Q: Hearty Company prepared the following bank reconciliation on June 30: Balance per bank ...

A: Cash receipts as per book = Total deposits in bank - Deposit in transit on June 30 ...

Q: Llewelyn Company purchased 3,600 shares of its own $8 par value common stock when the market price o...

A: To create a journal entry, you enter transaction details into ones company's books. Your journal ent...

Q: Problem 7-25 Low-Income Retirement Plan Contribution Credit (LO 7.9) George and Amal file a joint re...

A: Individual gross income (also known as gross pay on a paycheck) is the total earnings of an individu...

Q: Lucy must close the accounting books in the old system to have a complete set of financial statement...

A: In certain situations the business may decide to implement new systems for the recording of the acco...

Q: The auditor only obtains understanding of internal control related to significant risks identified i...

A: Internal control process is related with effective and efficient use of available resources and it w...

Q: Explain the three principal reasons organizations want to keep cash on hand or in bank accounts.

A: Introduction:- Cash on hand is the sum of money that your business has immediately available on the ...

Q: r-end by the lessee with a six-month advance notice. there is no renewal agreement. on july 8, 2016,...

A: A balance sheet refers to the financial statements which reflect the position of a company in terms ...

Q: Bambino Sporting Goods makes baseball gloves that are very popular in the spring and early summer se...

A: Ending inventory refers to the value of inventory lying with the entity at the end of the accounting...

Q: The following corporations are governed by the Revised Corporation Code, except: * A. Stock corporat...

A: Corporation- A corporation is an organization registered under any corporation act which makes its l...

Q: Determine the adjusted balance of the Home office account on the books of the branch as of December ...

A: ABC Company has a branch the balance of which in the home office books show a balance of P1,50,000. ...

Q: Partner X and Partner Y share profits and losses equally. Partner X and Partner Y receive salary all...

A: Interest on average capital For partner X = Php 110,000×10% = Php 11000 For partner Y = Php 90,000×...

Q: O60 260 300 Land 300 120 130 Buildings (net) 1,200 220 280 Equipment 360 100 75 Accounts payable 480...

A: Consolidation means combination of assets and liabilities and other financial items of two or more c...

Q: On January 1, Year 1, Bell Corporation issued $203,000 of 10-year, 6 percent bonds at their face amo...

A: Introduction:- A journal entry is the act of recording or keeping track of any financial or non-fina...

Q: $14,500 56,000 7,800 1,500 Cash Pirate Pete, Capital Oct. 1 Net loss Oct. 2017 Owner investments

A: Formula used for calculating Ending capital balance: Ending Capital Balance = Beginning Capital bala...

Q: Home Office P 256,000 Branch Sales P 78,500 Purchases from outsiders 210,000 20,000 Shipments to bra...

Q: Many producers of complex products actually combine manufacturing processes with assembly duties. Th...

A: The technique of replacing a projected cost for just an actual cost within accounting records would ...

Q: Which of the following payments will be subject to Canada Pension Plan contributions?

A: Pension is the amount which is given to the employee post retirement and for which the same employee...

Q: Gail is a single elementary school teacher. She buys the following items for use in her classroom in...

A: Construction paper and tissues $45 Materials for decorating the classroom bulletin boards $200 A...

Q: 3. The following information came from the books and records of ABC Corporation and its branch. The ...

A: The question is related to net income and net income is calculated from sales-cost of goods sold sel...

Q: Raddus is a technology company and has an enterprise value of $100 million. It currently has $25 mil...

A: Equity seems to be the worth of ownership in anything in the realm of business and finance. Equity c...

Q: Required information Skip to question [The following information applies to the questions display...

A: comment Since we only answer up to 3 sub-parts, we’ll answer the first 3. Please resubmit the qu...

Q: A Addison, Inc. makes a single product, an indoor fireplace. Data for last year is as follo $420 - S...

A: The income statement can be prepared using various approaches as variable costing and absorption cos...

Question

How do I create an After tax Cash Flow Analysis? Use rounded answers for subsequent calculations

Net Present Value Analysis
Champion Company is considering a contract that would require an expansion of its food processing capabilities. The contract covers five years. To provide the required products, Champion would have to purchase additional equipment for $64,000. Champion
estimates the contract will provide annual net cash inflows (before taxes) of $26,000. For tax purposes, the equipment will be depreciated as follows:
Year 1 $8.000
Year 2 16,000
Year 3 16.000
Year 4 16.000
Year 5 8.000
Although salvage value is ignored in the tax depreciation calculations, Champion estimates the equipment will be sold for $8,000 after five years.
Assuming a 35% income tax rate and a 10% hurdle rate, compute the net present value of this contract proposal. Using net present value analysis, should Champion accept the contract?
Round answers to the nearest whole number. Use rounded answers for subsequent calculations.
Use a negative sign with net present value to indicate a negative amount. Otherwise do not use negative signs with your answers.
After-Tax Cash Flow Analysis
Amount Present Value
After-tax cash inflows for S years
Tax savings from depreciation
Year 1
Year 2
Year 3
Year 4
Year 5
After-tax equipment sale proceeds
Total present value of future ash flows
Investment required in equipment
Net positive (negative) present value
Should Champion accept the contract?

Definition Definition Net amount of cash that an entity receives and expends over the course of a given period. For a business to continue operating, positive cash flows are required, and they are also necessary to produce value for investors. Investors in particular prefer to see growing cash flows even after capital expenditures have been paid for (which is known as free cash flow).

Expert Solution

Step 1

Net present value is the difference between present value of cash inflows and present value of cash outflows from the business. A positive NPV indicates that project should be accepted, otherwise not.

Step by step

Solved in 2 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.

Similar questions

Postman Company is considering two independent projects. One project involves a new product line, and the other involves the acquisition of forklifts for the Materials Handling Department. The projected annual operating revenues and expenses are as follows: Required: Compute the after-tax cash flows of each project. The tax rate is 40 percent and includes federal and state assessments.
NOT GRADED Net Present Value AnalysisChampion Company is considering a contract that would require an expansion of its food processing capabilities. The contract covers five years. To provide the required products, Champion would have to purchase additional equipment for $80,000. Champion estimates the contract will provide annual net cash inflows (before taxes) of $35,000. For tax purposes, the equipment will be depreciated as follows: Year 1 $10,000 Year 2 20,000 Year 3 20,000 Year 4 20,000 Year 5 10,000 Although salvage value is ignored in the tax depreciation calculations, Champion estimates the equipment will be sold for $10,000 after five years. Assuming a 35% income tax rate and a 10% hurdle rate, compute the net present value of this contract proposal. Using net present value analysis, should Champion accept the contract? Round answers to the nearest whole number. Use rounded answers for subsequent calculations.Use a negative sign with net present value to…
A nine year project involves equipment costing $2,320,000 that will be depreciated using the five-year MACRS schedule. If the estimated pre-tax salvage value for the equipment at the end of the project's life is $417,600, what is the after-tax salvage value for the equipment? Assume a marginal tax rate of 21 percent. O $329,904 $399.184 $6,496 O $505.296
HaulCo is considering the purchase of a truck. Over its five year life, it will provide net revenues of $17,000 per year at an initial cost of $72,000 and a salvage value of $21,000. HaulCo pays 35% in taxes, the CCA rate for trucks is 30%, and the after tax MARR is 12%. (a) What is the after tax annual cost or worth of this purchase? (b) Should HaulCo pursue this project? Why or why not?
A company plans to add an additional production line at an initial cost of $ 1,250,000 that will give gross savings of $ 1,000,000 per year for 6 years. The annual costs for operating this line would be $250,000 for the same period. For tax purposes the company uses sum-of-the-year-digits depreciation, a salvage value of $125,000 and a life of 6 years for evaluating the project... The debt ratio is 60% and the cost of debt is 12% and the debt obligation to be paid in 6 constant total yearly payment of interest and principal. The company’s tax rate is 40% and the minimum acceptable rate of return is 15% for total cash flows. On the basis of equity cash flows pls determine if the additional production line is viable? (Ignore investment tax credit and working capital)
New equipment costs $700,000 and is expected to last for four years with no salvage value. During this time the company will use a 30% CCA rate. The new equipment will save $550,000 annually before taxes. If the company's required rate of return is 15%, determine the NPV of the purchase. Assume a tax rate of 35%. $450,005 $461,112 $473,336 $485,550 $497,668
Esc You consider purchasing a new piece of equipment (7yr MACRS property) for your manufacturing process for $120,000. The equipment has a 6-year useful life and no salvage value. The equipment is expected to generate an additional $40,000 of net income before taxes and depreciation each year by using this upgraded system. The combined federal and state income tax rate= 35%. Annual inflation = 4%. a. Fill in the following table assuming MACRS depreciation rates Year 46°F Rain showers 0 1 F1 2 O 2 3 4 5 Pretax income 6 MACRS Taxable Depreciation income F2 - F3 + F4 Ⓡ b. If your MARR = 12%, should you purchase this system based on your real after-tax income? Why or why not? F5 8 C B Tax owed F6 Q Search G After tax income F7 Ca 7 F8 O Inflation adjustment factor O F9 ala LG F10 Real after tax income 0 A I THE F11 - 0 1 asod F12 + Prt Sc ScrLk Post-it sod Ins Post-it Del Backspace Post-it PgUp Home asod> Post-it Mumi 1-10 PgOn End Pause Break 11-15 11-15 C
A company is evaluating a new 4-year project. The equipment necessary for the project will cost $2,950,000 and can be sold for $660,000 at the end of the project. The asset the 5-year MACRS class. The depreciation percentage each year is 20.00 percent, 32.00 percent, 19.20 percent, 11.52 percent and 11.52 percent, respectively. The company's tax rate is 35 percent. What is the aftertax salvage value of the equipment?
A corporate expects to receive $35,900 each year for 15 years if a particular project is undertaken. There will be an initial investment of $121,595. The expenses associated with the project are expected to be $7,608 per year. Assume straight-line depreciation, a 15-year useful life, and no salvage value. Use a combined state and federal 48% marginal tax rate, MARR of 8%, determine the project's after-tax net present worth.
An investment of $600,000 is made in equipment that qualifies as 3-year equipment for MACRS-GDS depreciation. The before-tax cash flows, measured in constant dollars, for the investment consist of a uniform annual series of $200,000 plus a $200,000 salvage value at the end of the 5-year planning horizon. A 25% tax rate and 3% inflation rate apply. The real ATMARR is 10%. Determine the after-tax cash flows, in constant dollars, for each year. Determine the present worth for the investment. Determine the real internal rate of return for the investment If you could please show me the calculations in excel I would really appreciate it.
As a member of UA Corporation's financial staff, you must estimate the Year 1 cash flow for a proposed project with the following data. Under the new tax law, the equipment used in the project is eligible for 100% bonus depreciation, so it will be fully depreciated at t = 0. What is the Year 1 cash flow? Do not round the intermediate calculations and round the final answer to the nearest whole number. Sales revenues, each year $45,500 Other operating costs $22,522 Interest expense $4,000 Tax rate 25.0%
A company is considering a new project whose data are shown below. The required equipment has a 3- year tax life, and the accelerated rates for such property are 33%, 45%, 15%, and 7% for Years 1 through 4. Revenues and other operating costs are expected to be constant over the project's 10-year expected operating life. What is the project's Year 4 cash flow? Equipment cost (depreciable basis) $70,000 Sales revenues, each year $52,000 Operating costs (excl. depr.) $25,000 Tax rate 35.0%