Filling in where “?” Are present Requirement 1Chapter 7: Applying ExcelDataExample ECost of equipment neededWorking capital neededOverhaul of equipment in four yearsSalvage value of the equipment in five yearsAnnual revenues and costs:Sales revenuesCost of goods soldOut-of-pocket operating costsDiscount rateRequirement 2aPurchase of equipmentInvestment in working capitalSalesCost of goods soldOut-of-pocket operating costsOverhaul of equipmentSalvage value of the equipmentWorking capital releasedTotal cash flows (a)Discount factor (14%) (b)Present value of cash flows (a) x (b)Net present value$120,000$80,000$40,000$20,000Enter a formula into each of the cells marked with a ? belowExhibit 7-8$255,000$160,000$50,00011%Now*Use the formulas from Appendix 7B:Present value of $1 = 1/(1+r)^nPresent value of an annuity of $1 = (1/r)*(1-(1/(1+r)^n))where n is the number of years and r is the discount rate??????1Requirement 2 b??????2??????Years3??????Requirement 2 c4???????5????????F

The difference between the current value of cash inflows and outflow of cash over a period of time…

Answered: Cost of equipment needed Working…

Essentials Of Investments

11th Edition

ISBN:9781260013924

Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Chapter1: Investments: Background And Issues

Section: Chapter Questions

Problem 1PS

See similar textbooks

Similar questions

Cash Flow Asset End of Year Amount Appropriate Required Return B 1 through Infinity $300 15% using cell References to the given data, calculate the value of asset B
Cash Flow Asset End of Year Amount Appropriate Required Return B 1 through Infinity $300 15% using cell References to the given datea, calculate the value of asset B
Connect: Cha... 6 Table 9.7 Modified ACRS depreciation allowances Saved Help Save & Exit Submit Property Class Year 3-Year 5-Year 7-Year Check my work 1 33.33% 20.00% 14.29% 2 44.45 32.00 24.49 3 14.81 19.20 17.49 4 7.41 11.52 12.49 An asset used in a four-year project falls in the five-year MACRS class (MACRS schedule) for tax purposes. The asset has an acquisition cost of $7,200,000 and will be sold for $1,620,000 at the end of the project. If the tax rate is 24 percent, what is the aftertax salvage value of the asset? Note: Do not round intermediate calculations and round your answer to the nearest whole number, e.g., 32. 7 5 11.52 8.93 6 5.76 8.92 8.93 8 4.46 Aftertax salvage value
Exercise 24-2 (Algo) Payback period, equal cash flows, and depreciation adjustment LO P1 Quary Company is considering an investment in machinery with the following information. Initial investment Useful life Salvage value Expected sales per year Required A Required B (a) Compute the investment's annual income and annual net cash flow. (b) Compute the investment's payback period. $ 380,000 Complete this question by entering your answers in the tabs below. Annual Amounts 9 years $ 20,000 19,000 units Expenses Materials, labor, and overhead (except depreciation) Depreciation-Machinery Selling, general, and administrative expenses Selling price per unit Compute the investment's annual income and annual net cash flow. Income Net cash flow Required A $ Income 0 $ Cash Flow Required B > 0 $ 85,500 40,000 9,500 $ 10
Objective: Should WAW lease or construct their own production facilityOption 1: ConstructCosts to incur:Buying land, construct building and getting ready for use$ 230,000Taxes, insurance, and repairs (per year)$ 30,000Intended years of use20Projected market value in 20 years$ 1,600,000Maximum down payment WAW can make$ 500,000Remainder in four payments of;$ 180,000Option 2: LeaseIntended years of use20First lease payment due now$ 100,000Rest of the lease payments (years 2-20)$ 90,000Operating costs to be paid by WAWRepairs (annual)$ 7,000Maintenance (annual)$ 25,000Initial one-time deposit, will be returned in year 20$ 40,000Required rate of return15%Methodology:The consulting team is proposing to perform a NPV analysis and determine the benefit to leasing or construction.Based on the analysis, they will recommend the preferred option (construction or leasing).
MACHINE A MACHINE B INITIAL COST R100 000 R110 000 EXPECTED ECONOMIC LIFE 5 YEARS 5 YEARS EXPECTED DISPOSAL/RESIDUAL VALUE R10 000 EXPECTED NET CASH INFLOWS R R END OF: YEAR 1 34 000 33 000 YEAR 2 27 000 33 000 YEAR 3 32 000 33 000 YEAR 4 30 000 33 000 YEAR 5 26 000 33 000 DEPRECIATION PER YEAR 18 000 22 000 COMPANY ESTIMATES COST CAPITAL = 14% 2) Calculate the accounting rate of return (on average investment) for Machine A. (answer rounded offto 2 decimal places).
ems i Your firm is considering purchasing a machine with the following annual, end-of-year, book investment accounts. Gross investment Less: Accumulated depreciation Net investment Year 0 Year 1 Year 2 Year 3 Year 4 $ 65,000 $ 65,000 $65.000 $ 65,000 $65,000 0 16,250 32,500 48,750 65,000 AAR $ 65,000 $48.750 $ 32.500 $ 16,250 $ 0 The machine generates, on average. $4.900 per year in additional net income. What is the average accounting return for this machine? (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g.. 32.16.) Saved
Problem 9Hilarious Company provided the following data pertaining to machinery on the date of revaluation: Cost Replacement costMachinery 4, 500, 000 7, 500, 000Accumulated depreciation 900, 000 Age of asset 3 yearsRevised Life of the asset 10 years Required:1. Appreciation or revaluation increase2. Carrying amount3. Depreciated replacement cost4. Revaluation surplus5. What is the original life of the asset?6. Prepare the journal entry to record the revaluation 7. What is/are the rules in solving the problem?
MANAGEMENT OF TECHNOLOGY Project Selection Based on Economic Analysis 0.1 = MARR' Technology "A" Year Cost Income Net NPV IRR 0 -$650,000 $0 -$650,000 $148,621 17% 1 $0 $125,000 $125,000 2 $0 $175,000 $175,000 3 -$275,000 $300,000 $25,000 4 $0 $400,000 $400,000 5 $200,000 $200,000 $400,000 Technology "B" Year Cost Income Net NPV IRR 0 -$750,000 $0 1 $0 $175,000 2 $0 $200,000 3 -$370,000 $225,000 4 $0 $375,000 5 $300,000 $350,000 Technology "C" Year Cost Income Net NPV IRR 0 -$808,300 $0 1 $0 $200,000 2 $0 $225,000 3 -$265,000 $250,000 4 $0 $400,000 5 $202,000 $325,000 Increment B-A Year Cost Income Net NPV IRR 0 -$100,000 $0 -$100,000 -$23,453 5% 1 $0 $50,000 $50,000 2 $0 $25,000 $25,000 3 -$95,000 -$75,000 -$170,000 4 $0 -$25,000 -$25,000 5 $100,000 $150,000 $250,000 Increment C-A Year Cost Income Net NPV IRR 0 -$158,300 $0 1…
E10-4 Distinguishing capital expenditures from expenses [5 min] Classify each of the following expenditures as a capital expenditure or an expense related to machinery: a purchase price b ordinary recurring repairs to keep the machinery in good working order c lubrication before the machinery is placed in service d periodic lubrication after the machinery is placed in service e major overhaul to extend useful life by three years f customs duty paid on the purchase price g transport and insurance while machinery is in transit from seller to buyer h installation i training of personnel for initial operation of the machinery j income tax paid on profit earned from the sale of products manufactured by the machinery.
Question content area top Part 1 (IRR calculation) Determine the IRR on the following projects: a. An initial outlay of $13,000 resulting in a single free cash flow of $17,165 after 9 years b. An initial outlay of $13,000 resulting in a single free cash flow of $46,394 after 15 years c. An initial outlay of $13,000 resulting in a single free cash flow of $105,001after 25 years d. An initial outlay of $13,000 resulting in a single free cash flow of $13,653 after 4 years
Should WMM lease or construct their own production facility Option 1: Construct Costs to incur: Actual expenditure towards buying land, construct building and getting ready for use $ 500,000Taxes, insurance, and repairs (per year) $ 20,000Intended years of use 18Projected market value in 18 years $ 1,000,000 Budgeted maximum expenditure towards buying land, construction of building and getting ready for use. $ 500,000Remainder in four payments of; $ 175,000Option 2: LeaseIntended years of use 18First lease payment due now $ 100,000Rest of the lease payments…

SEE MORE QUESTIONS

Recommended textbooks for you

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS