You are trying to decide between four machines for your firm. These machines only differ in their lifespan, initial cost, and annual maintenance costs... they are identical in every other way. This investment is vital to the operations of your firm, so you will need one of these machines in order to stay in business; that means, when the machine quits working, you will need to immediately reinvest in the same machine. You are looking for the cheapest machine. And you will reinvest in the same machine as switching between machines would create switching costs that would be significant. 2. Annual costs each Initial cost today Machine Lifespan year $2.5 milliona $50 milliona 5 years 8 years 4 years 10 years AC $57 milliona $47 million $75 milliona $3.5 million Cа $2.0 million $2.0million The cost of capital for the new machine is 10%. Use the same common end-year approach to rank the machines in order from best to worst. (Using Excel will help with this.) a. b. Use the equivalent annual annuity approach to Tank the machines in order from best to worst.

Question

Need help to figure this problem and put into excel format with formulas.

You are trying to decide between four machines for your firm. These machines only differ
in their lifespan, initial cost, and annual maintenance costs... they are identical in every
other way. This investment is vital to the operations of your firm, so you will need one of
these machines in order to stay in business; that means, when the machine quits working,
you will need to immediately reinvest in the same machine. You are looking for the
cheapest machine. And you will reinvest in the same machine as switching between
machines would create switching costs that would be significant.
2.
Annual costs each
Initial cost today
Machine
Lifespan
year
$2.5 milliona
$50 milliona
5 years
8 years
4 years
10 years
AC
$57 milliona
$47 million
$75 milliona
$3.5 million
Cа
$2.0 million
$2.0million
The cost of capital for the new machine is 10%.
Use the same common end-year approach to rank the machines in order from best to
worst. (Using Excel will help with this.)
a.
b.
Use the equivalent annual annuity approach to Tank the machines in order from best to
worst.
Expand
Transcribed Image Text

You are trying to decide between four machines for your firm. These machines only differ in their lifespan, initial cost, and annual maintenance costs... they are identical in every other way. This investment is vital to the operations of your firm, so you will need one of these machines in order to stay in business; that means, when the machine quits working, you will need to immediately reinvest in the same machine. You are looking for the cheapest machine. And you will reinvest in the same machine as switching between machines would create switching costs that would be significant. 2. Annual costs each Initial cost today Machine Lifespan year $2.5 milliona $50 milliona 5 years 8 years 4 years 10 years AC $57 milliona $47 million $75 milliona $3.5 million Cа $2.0 million $2.0million The cost of capital for the new machine is 10%. Use the same common end-year approach to rank the machines in order from best to worst. (Using Excel will help with this.) a. b. Use the equivalent annual annuity approach to Tank the machines in order from best to worst.

Expert Answer

Want to see the step-by-step answer?

Check out a sample Q&A here.

Want to see this answer and more?

Experts are waiting 24/7 to provide step-by-step solutions in as fast as 30 minutes!*

*Response times may vary by subject and question complexity. Median response time is 34 minutes for paid subscribers and may be longer for promotional offers.
Tagged in
Business
Finance

Related Finance Q&A

Find answers to questions asked by students like you.

Q: How much is a share of Bama Corporation stock expected to be worth one year from now, if you pay $80...

A: According to the information provided, the stock has a current market price of $80, with a dividend ...

Q: Paul and Sandy Moede signed an $8000 note at Citizen's Bank. Citizen's charges a 6.50% discount rate...

A: Computation of effective rate of interest:Hence, the effective rate of interest is 6.87%.

Q: You have a loan outstanding. It requires making five annual payments of $7,000 each of the end of th...

A: In order to remain indifferent between the two options,One large payment at the end of the loan’s te...

Q: A equal principal payment loan of $3000 is amortized by means of 12 quarterly payments, beggining on...

A: Loan Amount = $3,000Total Number of Payments = 12Loan Principal Payment = $3,000 ÷ 12 = $250Interest...

Q: What mortgage would result in a higher payment? Mortgage A  $985 a month for 30 years or Mortgage B ...

A: Click to see the answer

Q: Campbell Supper Co. paid a $0.672 dividend per share in 2013, which grew to $0.82 in 2016. This grow...

A: Dividend per Share in 2013 (pv) = $0.672Dividend per Share in 2016 (fv) = $0.82Time Period (nper) = ...

Q: I'm struggling on this problem and have to put it into excel with formulas.

A: Computation of the stock price:

Q: A stock has yielded returns of 6 percent, 11 percent, 14 percent, and -2 percent over the past four ...

A: The formula to calculate mean value is given below:

Q: Critically discuss the effect of increasing the amount paid upfront when corporations make capital p...

A: Capital purchases refer to the expenses a company makes for buying new equipments, improving long te...

Q: Hello, It is a three part question. However, I would like to know how the amount of 122, 265, was ca...

A: 3.Calculate the net present value as follows:

Q: Josh borrowed $500 for 1 year and paid $50 in interest. The bank charged a $5 service charge. What i...

A: Finance charge:Finance charge means the total amount of charges of loan and interest paid throughout...

Q: a firm has a debt-to-equity ratio of 1.0. if we assume that the firm's debt pays 11% interest annual...

A: Hence, cost of debt after tax is 6.6%.The cost of debt is determined by multiplying cost of debt bef...

Q: Problem        “Suppose that your parents are willing to lend you $20,000 for part of the cost of yo...

A: To calculate rate on saving that would accumulate $ 20,000 in 60 months, if interest is compounded m...

Q: You buy stock for $30 per share and sell it for $33 per share after holding it for slightly after a ...

A: Since the stock is held for more than a year, both income and capital gains will be taxed differentl...

Q: MMS Corp borrows $1,650,000 today for a new building. The loan is an equal principal payment loan wi...

A: Calculation of Interest Payment due in Month 16:The interest payment due in month 16 is $7,985.21.Ex...

Q: The CFO of briggs industries is evaluating a capital budgeting project that should extend over 4year...

A: a) Depreciation using both MACRS and Straight-line method is calculated as below, with calculations ...

Q: Calculate the value of x for the cash flows below such that the equivalent total value in year 8 is ...

A: Equivalent value of a cash flow, Ct occurring at time t, at the end of year n = Ct x (1 + r)n - t wh...

Q: A Brazilian company called Netshoes completed its IPO on April 12, 2017, and listed on the NYSE. Net...

A: Excel spread sheet:

Q: You lent $290 to a friend for one year at a nominal rate of interest of 3 percent. Inflation during ...

A: Real interest rate is the real return earned on the amount lent which can be calculated by using fis...

Q: Market Top Investors, Inc., is considering the purchase of a $365,000 computer with an economic life...

A: We will work out the cash fows year by year and the use the excel formula NPV to get the desired ans...

Q: What is Internal Rate of Return - Monthly Fixed Cash Flows with Reversions?  Please provide examples...

A: The internal rate of return is the one of the discounted techniques of capital budgeting which is us...

Q: a firm has an asset base with a market value of 5.3 million. ITs debt is worth 2.5 million. if 0.2 m...

A: Weighted average cost of capital can be used to estimate the rate which should be provided to invest...

Q: find the interest earned principle 8000 rate .06 compounded annually years 3

A: The formula to calculate accumulated value is given below:

Q: The CFO of briggs industries is evaluating a capital budgeting project that should extend over 4year...

A: Part A: Cost of Equipment = $100,000 Calculation of depreciation of each year under two different de...

Q: Executives at XYZ Corporation realize that they have too much liquid assets. They want to use this c...

A: The rate of return that an investor expects from the investmnet made is known as expected rate of re...

Q: A bond has an annual 8 percent coupon rate, a maturity of 10 years, a face value of $1,000, and make...

A: The formula to calculate price of bond is given below,

Q: You want to endow a scholarship that will pay $11,000 per year forever, starting one year from now. ...

A: Framework:If P is the perpetuity and r is the discount rate, then PV of a perpetuity = P / rAmount t...

Q: discuss the rationale behind the introduction of negative interest rate policies across economies wo...

A: “Hey, since there are multiple questions posted, we will answer first question. If you want any spec...

Q: If all prefers dividned payments that have been missed must be payed before any common stock dividne...

A: Preferred Stocks:Preferred stocks are those stocks whose dividend is fixed and gets the priority abo...

Q: How much will I need to deposit into an account to have $6,500,000 in 10 years earning 5 % compounde...

A: Present value can be defined as the amount which is to be set aside in order to have a pre-defined s...

Q: Brockman Corporation just paid a dividend of $2.00. The dividend is expected to grow at a constant r...

A: Computation of current price of stock:The intrinsic value or current price of stock is $74.67.Formul...

Q: Optimal corporation want to expand their manufacturing facilities they have two choices,first to exp...

A: In option 1, there is cost of $290,000 for two years.In option 2, there is proceeds from selling an ...

Q: Standsard revenue bonds are: A.  Backed by the full taxing authority of the municipality. B. Collate...

A: The correct answer is option (b).The revenue bond is defined as a use of proceed revenue bond which ...

Q: The ___ the expected return from a financial asset, the ____ the risk of not getting the money back ...

A: Expected Return of Financial Asset:It is the expected profit or loss that is earned from the investm...

Q: Suppose that some commercial bank has $100M in deposits and $20M in capital. Assuming a 10% minimum ...

A: Calculation of maximum amount of loan and securities bank can hold:Answer:The maximum amount of loan...

Q: Amortization schedule Set up an amortization schedule for a $25,000 loan to be repaid in equal inst...

A: The table that shows the complete payments until the loan amount is totally paid off is known as amo...

Q: A metallurgical engineer decides to set aside money for his newborn daughter's college education. He...

A: Let’s assume the engineer deposits X for one year for 14 years:

Q: Tony Ring wants to attend Northeast College. He will need $66,000, 4 years from today. Assume Tony's...

A: Future Amount required (fv) = $66,000Interest Rate = 12%Type of Interest Compounded = SemiannuallyNu...

Q: Protective covenants protect:   Group of answer choices A. the investor from interest rate risk. ...

A: A protective convenant is a part of a bond indenture (legal contract or loan agreement). The scope a...

Q: bMy Questions bartleby X X [Solved] Buy Coastal, InX C Consider The Following X payback period formu...

A: Hello. Since you have posted multiple questions and not specified which question needs to be solved,...

Q: A small minority firm invested $100000 for a project. At an interest rate of 15% per year, compounde...

A: In order to recover the invested amount, present value of all bimonlthy incomes can be equated to th...

Q: (Future value) Sales of a new finance book were 15,000 copies this year and were expected to increas...

A: Sales this year = S0 = 15,000 copiesAnnual growth rate in sales = g = 20%

Q: At time 0 you had $2500 in the bank and 21 years later you had $15650.  Calculate the effective annu...

A: Effective interest rate can be described as the interest rate gained or paid in actual on a project....

Q: A 2-year Treasury security currently earns 1.77 percent. Over the next two years, the real risk-free...

A: Calculate the maturity risk premium as follows:

Q: Part 1: The CFO of Cruz, inc. is considering Projects A and B which are considered equally risky; th...

A: As per Q&A guidelines, we should answer the first three subparts when multiple subparts given un...

Q: Q2)   Suppose the current one-year euro swap rate y0[0, 1] is 1.74%, and the two-yearand three-year ...

A: Meaning of Euro swap rate:A swap rate is the fixed rate that a receiver demands, in exchange for unc...

Q: Suppose that 10 years ago you bought a home for $150,000, paying 10% as a down payment, and financin...

A: Calculation of Amount of Money Paid to the Loan in 10 years:The amount of money paid to the loan in ...

Q: Why capital structure is so crucial for the chief of any corporate department? Last but not lease, e...

A: Capital structure refers to the percentage or weight of debt and equity in the total capital of a fi...

Q: Rank the following three stocks by their total risk level, highest to lowest. Night Ryder has an ave...

A: Calculation of the Total Risk Level of Night Ryder Stocks, WholeMart Stocks and Fruit Fly Stocks usi...

Q: E. dual class 10. Which of the following indexes are value-weighted?" I. NYSE Composite II. S&P 500 ...

A: The market capitalization of each company helps in determining the its weight in the index whereas i...