Question

In: Finance

Can you please show me how to do this on excel with formulas. I am having...

Can you please show me how to do this on excel with formulas. I am having a difficult time understanding how to incorporate the depreciation into the problem! Thank you

You are evaluating two different milling machines to replace your current aging machine. Machine A costs $248868, has a three-year life, and has pretax operating costs of $58935 per year. Machine B costs $406397, has a five-year life, and has pretax operating costs of $33004 per year. For both milling machines, use straight-line depreciation to zero over the project’s life and assume a salvage value of $40886. Your tax rate is 34 % and your discount rate is 10 %.

What is the EAC for Machine A?

Solutions

Expert Solution


Related Solutions

Please show me how to do the following in excel. An additional "show formulas" would also...
Please show me how to do the following in excel. An additional "show formulas" would also be helpful. NOK Plastics is considering the acquisition of a new plastic injection-molding machine to make a line of plastic fittings. The cost of the machine and dies is $125,000. Shipping and installation is another $8,000. NOK estimates that new project will require $7,500 in inventory, and result in a $7,500 increase in accounts receivable and a $5,000 increase in accounts payable. The latter...
Can someone do this in Excel and show me the formulas as well. The management of...
Can someone do this in Excel and show me the formulas as well. The management of Tri-County Air Taxi, Inc., is considering the replacement of an old machine used in its helicopter repair facility. It is fully depreciated but it can be used by the corporation through 20x5. If management decides to replace the old machine, James Transportation Company has offered to purchase it for $69,000 on the replacement date. The old machine would have no salvage value in 20x5....
PLEASE SHOW THE EXCEL INPUTS AND FORMULAS AS I AM VERY NEW TO THIS SUBJECT AND...
PLEASE SHOW THE EXCEL INPUTS AND FORMULAS AS I AM VERY NEW TO THIS SUBJECT AND WANT TO LEARN EXCEL INPUTS. Problem 7-18 Abandonment We are examining a new project. We expect to sell 6,300 units per year at $57 net cash flow apiece for the next 10 years. In other words, the annual operating cash flow is projected to be $57 × 6,300 = $359,100. The relevant discount rate is 12 percent, and the initial investment required is $1,740,000....
Can you please show me the formulas you used in these problems? I keep using the...
Can you please show me the formulas you used in these problems? I keep using the wrong ones. In his last ride in a rocket sled in 1955, Col. Stapp was accelerated to 632 miles per hour in 5.0 s, and then brought to a stop with an acceleration of 46.2 g, the largest acceleration voluntarily endured by a human. a. How far did the sled move in the first phase, as it accelerated to maximum speed? b. How far...
Can you do in excel please and show the formulas Lunar Motivation Corporation Income Statement ($...
Can you do in excel please and show the formulas Lunar Motivation Corporation Income Statement ($ in millions)                                                                                     2019                                                                Sales                          8000                                                                             Cost of Goods           -5600                                                  SGA                           -1500                                                  Interest                        -100                                                  EBT                              800                                                  Taxes (40%)               -320                                                  Net income                   480                                                  Dividends                    -100                                                  Retained earnings        380                                                                                     ====                                                                                                                                                              Lunar Motivation Corporation Balance Sheet                                                2019                                                                          2019                  Cash                                         10                                     Accounts payable        300   Accounts receivables             400                                     Notes payable              300   Inventory                                560                                     Current liabilities          600   Short term Investments            30                                     Long-term debt          1000   Current assets                     1000                                     Common stock             400   Net plant & equip.                3000                                     Retained earnings      2000   Total assets                         4000                                     Total liab. & equity     4000                                               =====                                                                      =====                              You have forecasted Lunar Motivation Corporation (LMC) free cash flow in 2020 to be...
Please give me the excel formulas for these so i can study them I don't need...
Please give me the excel formulas for these so i can study them I don't need calculations just the formula and the name of it. maybe a brief sentence. an investment pays 7710.02 (F51) at the end of every year for 39 years (F52) interest rate is 13.17% (F53) what is this investment worth today? ---- you hope to earn a "ly" (yearly?) income of 701.38 (F59) interest rate you will earn on yor investments is 14.39% (F60) You expect...
Hello! Can you show me how to this problem by hand? No Excel please! An organization...
Hello! Can you show me how to this problem by hand? No Excel please! An organization is considering the purchase of new machines to automatically conduct some quality control tasks. The machines are expected to save production cost which is given below as Annual Income. The machines are expected to be part of the production process for 5 years. The company has a minimum attractive rate of return (MARR) of 5.4%. The following data is available for these new machines:...
Can you do in excel please and show Formulas The Air Marshal Co. has recently completed...
Can you do in excel please and show Formulas The Air Marshal Co. has recently completed a $10,000,000 two-year marketing study.  Based on the results of this study, Air Marshal has estimated that 800 units of its new security electro-optical human scanning hardware, known as "Marshal Dillon," could be sold annually over the next 12 years, at a price of $110,000 the first year with an estimated 2% annual rise from inflation in years 2-6.  The sales price is expected to drop...
Can you do in excel please and show Formulas The Air Marshal Co. has recently completed...
Can you do in excel please and show Formulas The Air Marshal Co. has recently completed a $10,000,000 two-year marketing study.  Based on the results of this study, Air Marshal has estimated that 800 units of its new security electro-optical human scanning hardware, known as "Marshal Dillon," could be sold annually over the next 12 years, at a price of $110,000 the first year with an estimated 2% annual rise from inflation in years 2-6.  The sales price is expected to drop...
Can you do in excel and include the excel show formulas The Air Marshal Co. has...
Can you do in excel and include the excel show formulas The Air Marshal Co. has recently completed a $10,000,000 two-year marketing study.  Based on the results of this study, Air Marshal has estimated that 800 units of its new security electro-optical human scanning hardware, known as "Marshal Dillon," could be sold annually over the next 12 years, at a price of $110,000 the first year with an estimated 2% annual rise from inflation in years 2-6.  The sales price is expected...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT