Question

In: Finance

Johnson and Company provides you the following information Purchase price of each Machine                            &nb

Johnson and Company provides you the following information

Purchase price of each Machine                                  300,000

Useful life of each machine                                        5 years

Salvage value                                                              100,000

Method of Depreciation                                             Straight line

Tax rate                                                                       50%

Cost of Debts                                                              10%

Earnings before depreciation & Tax

Machine

Year 1

Year 2

Year 3

Year 4

Year 5

X

200,000

10% increase

10% increase

10% increase

10% increase

Y

0

100,000

200,000

300,000

1200,000

Required which of the machine should be purchase on the following basis

  1. Payback period
  2. Net Present value
  3. IRR
  4. Which projects should be accepted?
  5. What is the concept of capital budgeting?
  6. What is the purpose of capital budgeting?

Solutions

Expert Solution

Machine X Year 0 Year1 Year2 Year3 Year4 Year5 Formula
Earnings before depreciation and tax (300,000)          200,000          220,000          242,000          266,200          292,820
Depreciation (Cost - Salvage value)/No of years          (40,000)          (40,000)          (40,000)          (40,000)          (40,000) (300,000-100000/5 years)
Net income          160,000          180,000          202,000          226,200          252,820
tax @ 50%          (80,000)          (90,000)        (101,000)        (113,100)        (126,410)
Profit after tax            80,000            90,000          101,000          113,100          126,410
Add depreciation (Non cash)          120,000          130,000          141,000          153,100          166,410
Net annual cash inflows          160,000          170,000          181,000          193,100          206,410
salvage value (No tax as salvage = cost after depreciation)          100,000
Total cash flows          160,000          170,000          181,000          193,100          306,410
PV factor @ 10% (1/1+r)^n 1 0.909090909 0.826446281 0.751314801 0.683013455 0.620921323
Discounted cash flows (300,000)          145,455          140,496          135,988          131,890          190,257
NPV - Sum of all years Cash flows    444,085
Machine Y Year 0 Year1 Year2 Year3 Year4 Year5
Earnings before depreciation and tax (300,000)                     -            100,000          200,000          300,000       1,200,000
Depreciation (Cost - Salvage value)/No of years          (40,000)          (40,000)          (40,000)          (40,000)          (40,000) (300,000-100000/5 years)
Net income          (40,000)            60,000          160,000          260,000       1,160,000
tax @ 50%            20,000          (30,000)          (80,000)        (130,000)        (580,000)
Profit after tax          (20,000)            30,000            80,000          130,000          580,000
Add depreciation (Non cash)            20,000            70,000          120,000          170,000          620,000
Net annual cash inflows            60,000          110,000          160,000          210,000          660,000
salvage value (No tax as salvage = cost after depreciation)          100,000
Total cash flows            60,000          110,000          160,000          210,000          760,000
PV factor @ 10% (1/1+r)^n 1 0.909090909 0.826446281 0.751314801 0.683013455 0.620921323
Discounted cash flows (300,000)            54,545            90,909          120,210          143,433          471,900
NPV - Sum of all years Cash flows    580,998

NPV of project Y is greater than X and should be taken up.

2. Capital budgeting is a process which is used to determine if the proposed project can be accepted or declined. This process is to create an financial understanding of each proposal and evaluate the same.

3. Same as above. Purpose to is identify if a given project can be accepted or not, if the NPV is positive, then the project can be accepted. Project which has the greater NPV is more profitable. There are various tools to identify the profitability and one such tool is NPV, which is present value of cash inflows - Ouflows which is the net profit discounted to present terms.


Related Solutions

Property Assumptions Purchase Price:                                    &nb
Property Assumptions Purchase Price:                                                                        $12,500,000 Year 1 Potential Rental Income (PRI):                                    $1,650,000 PGI annual growth rate:                                                          3% Annual Vacancy and Credit Loss (VCL):                               5%             Over next 6yrs. Year 1 operating expenses (OER): (Oper. Expense Ratio)     35% OPEX annual growth rate (after year 1):                                 2% Sales Price :     Terminal Cap Rate                                           .09 Capitalize 6th yr. NOI Sales Costs: Commissions                                                      3% of Sales Price Anticipated holding period                                                      5 years Maximum loan-to-value (LTV) ratio:                                      75% Interest Rate:                                                                           5.25% Amortization Period:                                                               20 years...
Simmons Company is considering the purchase price of a new floor machine. The purchase price of...
Simmons Company is considering the purchase price of a new floor machine. The purchase price of the equipment is $420,000 and it is expected to have a useful life of 7 years with no salvage value. The company uses straight line depreciation and pays income taxes at a rate of 25%. If the company requires that all new equipment investments pay for themselves within 3 years, how much annual cash operating savings must the floor machine generate, if it is...
Aurora Company is considering the purchase of a new machine. The invoice price of the machine...
Aurora Company is considering the purchase of a new machine. The invoice price of the machine is $123,000, freight charges are estimated to be $4,000, and installation costs are expected to be $5,000. Salvage value of the new equipment is expected to be zero after a useful life of 5 years. Existing equipment could be retained and used for an additional 5 years if the new machine is not purchased. At that time, the salvage value of the equipment would...
The following information relates to the Jimmy Johnson Company.                                &nbs
The following information relates to the Jimmy Johnson Company.                                     Ending Inventory                    Ending Inventory Date     At Base-Year Cost At Current Year Cost Price Index ___________________________________________________________________________________________ 12/31/15 (base)                 $68,400                                  $68,400                                    1.00 12/31/16                            $91,600                                 $122,744                                   1.34 12/31/17                            $89,800                                 $132,904                                   1.48 Using dollar-value LIFO, 2016 ending inventory is? Using dollar-value LIFO, 2017 ending inventory is? What is the change in inventory in base-year prices in 2016 (i.e., comparing 2016 ending...
Blendy Company provides the following balance sheet and income statement for the year of 2018.                           &nb
Blendy Company provides the following balance sheet and income statement for the year of 2018.                                                             HARVEY COMPANY                                                           BALANCE SHEET                                                   AS OF 31 DECEMBER, 2018                        ASSETS                                                                                     “$”                  Current Assets:                 Cash in hand                                                                              100,000                 Inventory                                                                                      90,000                Debtors                                                                                        145,000              Total current assets                                                                    3, 35,000             Non-Current Assets:                         Total non-current assets                                                             2,530,000               Total Assets                                                                                  2,865,000                  LIABILITIES            Current Liabilities:          Total Current liabilities                                                                     5,22,000           Non-Current Liabilities:           Long term loan...
Jay Company provides you with the following information for the current accounting period:
Part AJay Company provides you with the following information for the current accounting period:            Sales (net)                                                       $400,000            Beginning inventory at cost                               80,000            Purchases (net)                                               230,000Required:Assuming gross profit is 40% of sales, compute an estimate of Jay Company’s ending inventory.Assuming gross profit is 40% of cost, compute an estimate of Jay Company’s ending inventory.
O’Connor Company ordered a machine on January 1 at a purchase price of $90,000. On the...
O’Connor Company ordered a machine on January 1 at a purchase price of $90,000. On the date of delivery, January 2, the company paid $23,000 on the machine and signed a long-term note payable for the balance. On January 3, it paid $900 for freight on the machine. On January 5, O’Connor paid cash for installation costs relating to the machine amounting to $5,400. On December 31 (the end of the accounting period), O’Connor recorded depreciation on the machine using...
McPherson Company must purchase a new milling machine. The purchase price is $50,000, including installation.
McPherson Company must purchase a new milling machine. The purchase price is $50,000, including installation. The machine has a tax life of 5 years, and it can be depreciated according to the following rates. The firm expects to operate the machine for 4 years and then to sell it for $12,500. If the marginal tax rate is 40%, what will the after-tax salvage value be when the machine is sold at the end of Year 4?
Tonga Corporation incurred the following expenditures to purchase a new machine: $100,000 purchase price, $12,000 for...
Tonga Corporation incurred the following expenditures to purchase a new machine: $100,000 purchase price, $12,000 for delivery of the machine, $5,000 for installation and testing of the machine, $4,000 to train staff to run the machine. In addition, the firm paid $2,000 to reinforce the factory floor to support the machine’s weight. They also paid $20,000 to repair the factory roof, extending the life of the factory by 4 years and $10,000 to create office space for the supervisor of...
ABC Company has provided the following information from their records:                               &nb
ABC Company has provided the following information from their records:                                                                          Purchases                                         Sales                                                                                 Units             Unit Cost              Units     Selling Price/Unit Mar       1         Beginning inventory          100                  $50              3         Purchase                             60                  $60              4         Sales                                                                                   70                   $100            10         Purchase                           200                  $70            16         Sales                                                                                   80                   $110            19         Sales                                                                                   80                   $110            25         Sales                                                                                   50                   $110            30         Purchase                             40                  $75 Using the inventory and sales data above, to complete the below inventory schedule under FIFO method and prepare the journal entries...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT