Question: Please show all work on excel with references thank you. Adams Corporation is planning to buy a machine that will cost $40,000 and depreciate it

Please show all work on excel with references thank you. Adams Corporation is planning to buy a machine that will cost $40,000 and depreciate it on a straight-line basis over a 5-year period with no residual value. The tax rate of Adams is 30%, and the proper discount rate is 15%. The earnings before taxes from the machine are uncertain, but their expected value is $15,000 a year, with a standard deviation of $3,000.

Find the break-even earnings before tax.
Calculate the probability that the machine will be a profitable investment. Adams requires the probability of being profitable to be more than 60% to buy the machine. Based on your calculation, should Adams buy the machine?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Land City leases a fleet of garbage trucks. The term of the lease is 10 years, approximately the useful life of the equipment. Based on a sales price of $800,000 and an interest rate of 6%, the city...

on excel No. s (Capital Budgeting) Adams Corporation is planning to buy a machine that will cost $40,000 and depreciate it on a straightline basis over a 5-year period with no residual value. The tax...

USE EXCEL TO SHOW FORMULAS Adams Corporation is planning to buy a machine that will cost $40,000 and depreciate it on a straight-line basis over a 5-year period with no residual value. The tax rate...

AutoSave OFF H 5 + 5 = wa Douglas Case rev 9_7_21(2) (1) Home Insert Draw Design Layout References Mailings Review View Tell me Share Q Comments X LO Calibri (Bo... V 11 21 AaBbcDdEe AaBbCcDdEe AaBb...

Complete tabs 11.9, 11.16, 11.22, 11.24, 11.25, and 11.32 in the attached Chapter 11 Excel spreadsheet. An EXAMPLE tab is provided in the spreadsheet for your guidance. You must use formulas in the...

**Please Complete in Excel & SHOW FORMULA'S** John's Corporation is planning to buy a machine that will cost $40,000 and depreciate it on a straight-line basis over a 5-year period with no residual...

Differential Analysis Problems Attached Files: 7 Differential Analysis Problems.xIsx (9) (40.262 KB) Instructions: 1. The attached Excel file contains a series of Differential Analysis problems,...

Please show formulas used in excel! thanks! B C G H D TCICI CHCE EU che cu m WHICH THE Lata is vumu. IVIANE Your computations my mu me viu ccus mgmgmcu ve Woman cases, mics (HCI WISC directed, use...

I have an assignment for Finance Management: Payback Periods, Net Present Value, Internal rate of return , NPV, Equivalent Annual Annuity, Estimation CF, Capital Rationing. Please see excel...

Please show your calculations and formula. The last 2 files are the example to to fill out the result. Thank you so much. Introduction Siobhan McGurkin, chief operating officer for the Aviator...

Sparkles Dessert Cafe Please read the instructions carefully and provide what is being requested. A new client of yours, Bailey Waters wants to open a small dessert cafe selling cupcakes, pie slices,...

Nancy Castle Company purchased a computer system for $60,000 on January 1, 2006. It was depreciated based on a 7-year life and an $18,000 salvage value . On January 1, 2008, Castle revised these...

(a) Show that the sample variance is unchanged if a constant c is added to or subtracted from each value in the sample. (b) Show that the sample variance becomes c2 times its original value if each...

4 Match each description with the correct expression. The first one has been done for you: a and iv. a Multiply n by 5 and subtract 4 b Add 4 and n, then multiply by 5 c Multiply n by 5 and add 4 d...

A company is preparing completing their Cash Budget. The following data has been prepared for cash receipts and payments. January February March Cash receipts $1,061,200 $1,182,400 $1,091,700 Cash...