Explain how to solve the problem on excel

Assignment Help Business Economics
Reference no: EM13154121

A firm is considering two alternatives that have no salvage value.

A
Initial Cost $10,700
Uniform Annual Benefits 2,100
Useful life, in years 8

B
Initial Cost $5,500
Uniform Annual Benefits 1,800
Useful life, in years 4

At the end of 4 years, another B may be purchased with the same cost, benefits, and so forth.

(a) Construct a choice table for interest rates from 0% to 100%

(b) If the MARR is 10%, which alternative should be selected?

Can you please explain how to solve the problem on excel

 

Reference no: EM13154121

Questions Cloud

Strengths-weaknesses of various types of accounting : Are there any difference between the organizations that adopt a particular accounting method? What are the strengths and weaknesses of the various types of accounting?
Calculate the federal estate tax due on his estate. : When Russell Hypes died unmarried in 2012, he left an estate valued at $6,650,000. His trust directed distribution as follows: $15,000 to the local hospital, $75,000 to his alma mater, and the remainder to his three adult children. Death-related cost..
Gain recognized on the transfer : The liability is assumed by the partnership. Brad transfers property (basis of $16,000, fair market value of $7,500) for a 25% interest, and Rick transfers cash of $15,000 for the remaining 50% interest. a. How much gain must Lee recognized on the..
Find probability that more than half are heavy smokers : One prominent physician claims that 70% of chose with lung cancer are heavy smokers. If his assertion is correct. find the probability that more than half are heavy smokers.
Explain how to solve the problem on excel : Construct a choice table for interest rates from 0% to 100%. If the MARR is 10%, which alternative should be selected? Can you please explain how to solve the problem on excel
Effects of transactions and accounting equation : You are required to write a report to your boss to help her understand these terms trial balance, cash book, general journal, books of prime entry effects of transactions and accounting equation.
What is the partial pressure of the nitrogen gas : nitrogen gas was collected over water at a temperature of 40 degrees C, and the pressure of the sample was measured at .796 mmHg. if the vapor pressure of water at 40 degrees C is 55 mmHg, what is the partial pressure of the nitrogen gas?
Operation on a natural business year end : The CEO of a major restaurant chain, whose sales vary by no more than 1-2 percent per month, recommends that the company operate on a natural business year end. As the president of the company, do you support this decision? Why or why not?
A mixture heated to produce gaseous : A mixture of CaCO3 and CaO weighing 0.680 g was heated to produce gaseous CO2. After heating, the remaining solid weighed 0.489 g.

Reviews

Write a Review

Business Economics Questions & Answers

  What is nick mrs of swimming in terms of basketball

What is Nick’s MRS of swimming in terms of basketball? Do his indifference curves exhibit diminishing MRS or constant MRS?

  Explain how much is to produce

Assume a perfectly competitive firm's short-run cost is TC = 120 + 160Q + 3Q2. If the market price is $196, what should it do. Elucidate your answer, if continue then explain how much is to produce; state profit level in each decision it makes.

  Why has sharp been so successful for so long

Why has Sharp been so successful for so long. Is Sharp today an end products or a components company. How is Sharp able to coordinate and integrate activities across corporation.

  Is the product considered elastic inelastic

Is the product considered elastic, inelastic or unitary elastic. In a few sentences Illustrate what effect does the present supply also present Demand have on this product.

  Official money lose its meaning in germany

Illustrate why did official money lose its meaning in Germany during the 1920s. What did the German government do or not do.

  Discuss the elements that make up australia current account

Discuss the elements that make up Australia's Current Account. Outline the cyclical and structural factors that have caused Current Account Deficits in the last decade.

  What would you do shut down or continue to operate

Illustrate what would you do shut down or continue to operate. Use hypothetical numbers to explain.

  How to produce and for whom to produce

mixed economic systems answer the three fundamental economic questions of what to produce, how to produce, and for whom to produce, including global environments

  Elucidate pros and cons associated with this case

If a country desires to have stable prices (or low inflation), why not simply pass a law that prohibits firms from changing prices? Elucidate pros and cons associated with this case.

  Construct a choice table based on the chosen marr

B would cost $1.5 and save $$400K pa. C would cost $2.1M and save $500K pa. For each of the alternatives. Construct a Choice Table based on the chosen MARR.

  Briefly elucidate why magnification effect plays

Briefly elucidate why magnification effect plays an important role in predicting where various groups in economy will support or oppose international trade.

  Construct the composite index

Just construct the diffusion index from month 2 to 3. In this problem, we have three leading indicators. The diffusion index from month 1 to 2 is 66.7 (=2/3) because two indicators move up and one moves down.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd