The following data are accumulated by Geddes Company in evaluating the purchase of $120,000 of equipment, having a four-year useful fe Net Income Net Cash Flow Year 1 $49,500 $79,500 Year 2 29,000 59,000 Year 3 16,500 46,500 Year 4 6,500 36,500 This information has been collected in the Microsot Excel Online fle. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. K) open spreadsheet a. Auming that the desired rate of return is 15%, determine the net present value for the proposal. f required, round to the nearest dollac Net present value b. Would management be lky to look with favor on the proposal? the net present value indicates that the return on the proposal is than the minimum desired rate of returm of 15%

The following data are accumulated by Geddes Company in evaluating the purchase of $120,000 of equipment, having a four-year useful fe Net Income Net Cash Flow Year 1 $49,500 $79,500 Year 2 29,000 59,000 Year 3 16,500 46,500 Year 4 6,500 36,500 This information has been collected in the Microsot Excel Online fle. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. K) open spreadsheet a. Auming that the desired rate of return is 15%, determine the net present value for the proposal. f required, round to the nearest dollac Net present value b. Would management be lky to look with favor on the proposal? the net present value indicates that the return on the proposal is than the minimum desired rate of returm of 15%

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

Units-of-activity depreciation A tractor acquired at a cost of $400,000 has an estimated residual value of $122,800, has an estimated useful life of 36,000 hours, and was operated 4,670 hours during the year. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. X Open spreadsheet Determine the following. Round your answer for depreciation rate to two decimal places. a. The depreciable cost b. The depreciation rate c. The units-of-activity depreciation for the year per hour
This is business algebra please show your work so I will understand the question.
Consider each of the transactions below independently. All of the expenditures were made in cash. 1. During 2020, PC Software Inc. developed a new personal computer database management software package. Total expenditures on the project were $300,000, of which 30% occurred before the technological feasibility of the product had been established. 2. Xon Corporation paid $50,000 to complete overhaul of the plumbing system (old costs unknown). 3. The Johnson Company disposed of an old machine with an original cost of $8,000 and a book value of $4,000 and received $3,000. Required: Prepare journal entries to record each of the above transactions. Note: You may create a table as follows to organize your journal entries. Date Account titles Debit Credit 1 Cash 10,000 Sales Revenue 10,000 Edit Format Table Paragraph v в I U A 12pt v
The financial statements of Columbia Sportswear Company are presented in Appendix B. Click here to view Appendix B. The financial statements of Under Armour, Inc. are presented in Appendix C. Click here to view Appendix C. The complete annual report, including the notes to the financial statements, is available at the company's website. (b) What conclusions concerning the management of plant assets can be drawn from these data? 1. 2. 3. Return on assets Profit margin Asset turnover Columbia Sportswear Company 12.0% 9.8% 1.22 times Under Armour, Inc. -1.1% -0.9% 1.26 times
Please answer all the letters from a to f. Please provide your solutions in good accounting form. Thank you so much. Please complete your answers with the requirements asked in the problem.
You have been assigned to check the valuation of InfoSystems, a software firm, done by a colleague of you. Infosystems has an expected life 5 years, constant cash flows over this period, and zero salvage value. The income statement of the Infosystems is given as follows: Revenues - Operating Expenses EBIT - Interest expenses Taxable Income - Taxes Net Income Years 1-5 €1,000 €550 €450 €85 €365 €146 €219 Infosystems has no capital expenditures, depreciation or working capital needs, i.e. the earnings are the cash flows to the firm. The cost of capital is 10% i. Estimate the value of Infosystems. ii. Assume that the value derived in (i) is the one also estimated by your colleague. How would you change your calculations if you are given that the cash flows are real cash flows and the cost of capital is the nominal cost of capital. The expected inflation rate is 2% annually. Comment on your answer.
Compute return on investment for each investment center. Which center performed the best on return on investment?
The capital investment committee of Ellis Transport and Storage Inc. is considering two investment projects. The estimated income from operations and net cash flows from each investment are as follows: Warehouse Tracking Technology Year Income fromOperations Net CashFlow Income fromOperations Net CashFlow 1 $44,000 $145,000 $92,000 $232,000 2 44,000 145,000 70,000 196,000 3 44,000 145,000 35,000 138,000 4 44,000 145,000 15,000 94,000 5 44,000 145,000 8,000 65,000 Total $220,000 $725,000 $220,000 $725,000 Each project requires an investment of $440,000. Straight-line depreciation will be used, and no residual value is expected. The committee has selected a rate of 10% for purposes of the net present value analysis. Present Value of $1 at Compound Interest Year 6% 10% 12% 15% 20% 1 0.943 0.909 0.893 0.870 0.833 2 0.890 0.826 0.797 0.756 0.694 3 0.840 0.751 0.712 0.658 0.579 4 0.792 0.683…
Use the following information for the Quick Study below. (Algo) [The following information applies to the questions displayed below.] The following information is provided for each Investment Center. Investment Center Cameras Phones Computers Income $ 6,400,000 2,145,000 900,000 QS 22-12 (Algo) Computing return on investment LO A1 Compute return on investment for each investment center. Which center performed the best based on return on investment? Investment Center Average Assets $ 29,600,000 16,500,000 15,200,000 Complete this question by entering your answers in the tabs below. Cameras Phones Computers Performance Return on Investment Based on ROI Compute return on investment for each investment center. (Round your final answer to 1 decimal place.) Average Assets $ 29,600,000 16,500,000 15,200,000 Answer is complete but not entirely correct. Income $ 6,400,000 2,145,000 900,000 Return on Investment 2.2 X % 0.2 X % 5.9 %
Tasty Doughnuts has computed the net present value for capital expenditure at two locations. Relevant data related to the computation are as follows: Des Moines Cedar Rapids Total present value of net cash flow $194,880 $254,100 Amount to be invested (203,000) (242,000) Net present value $(8,120) $12,100 a. Determine the present value index for each proposal. Round your answers for the present value index to two decimal places. Des Moines Cedar Rapids Total present value of net cash flow $fill in the blank 1 $fill in the blank 2 Amount to be invested $fill in the blank 3 $fill in the blank 4 Present value index fill in the blank 5 fill in the blank 6 b. Which location does your analysis support? (If both present value indexes are the same, either location will grade as correct.) , because the net present value index is 1.
The owner of a bicycle repair shop forecasts revenues of $196,000 a year. Variable costs will be $59.000, and rental costs for the shop are $39.000 a year. Depreciation on the repair tools will be $19.000. a. Prepare an income statement for the shop based on these estimates. The tax rate is 20% Calculate the operating cash flow for the repair shop using the three methods given below Now calculate the operating cash flow 1. Dollars in minus dollars out 2. Adjusted accounting profits, in 3.Add back depreciation tax shield
Cannington Inc. designs, manufactures, and markets personal computers and related software. Cannington also manufactures and distributes music players (cPod), mobile phones (cPhone), and smartwatches (Cannington Watch) along with related accessories and services, including online distribution of third-party music, videos, and applications. The following information was taken from a recent annual report of Cannington: Property, Plant, and Equipment (in millions): Current Year Preceding Year Land and buildings $494,500 $286,810 Machinery, equipment, and internal-use software 469,775 370,875 Other fixed assets 598,345 449,995 Accumulated depreciation and amortization (628,015) (524,170) a. Compute the book value of the fixed assets for the current year and the preceding year. Current year book value (in millions) $fill in the blank 1 Preceding year book value (in millions) $fill in the blank 2 A comparison of the…

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

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

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