Question
I need this solved step by step and by hand. Please no Excel. Thank You!

1 7) (35 points) EmKay, Inc. is considering the purchase of new automated equipment to increase its production capacity. For
0 0
Add a comment Improve this question Transcribed image text
Answer #1
Formula for loan amortization =
A= [i*P*(1+i)^n]/[(1+i)^n-1]
The details for the two loans are ;
A = periodical installment= ?
P=Loan amount = $                         200,000
i= interest rate per period 10% pa
n=total no of payments=                                   3.00
A= [10%*200000*(1.1)^3]/(1.1^3-1)
A =80422.96
So Annual Installment is $80,422.96
Ans a.
Year Beginning Balance loan Interest @10% Principal repaid Balance of loan
1                             200,000                       20,000                     60,423               139,577
2                             139,577                       13,958                     66,465                  73,112
3                               73,112                         7,311                     73,112                          -  
Ans b.
After Tax cash flow
MACRS Depreciation 3 yrs Year1 Year2 Year3 Year4
Depreciation Rate 33.33% 44.45% 14.81% 7.41%
Yearly depreciation on $450,000                       149,985.00               200,025.00                66,645.00            33,345.00
After Tax cash flow
Particulars Year1 Year2 Year3 Year4
Estimated Revenue $                         180,000 $                200,000 $               220,000 $           240,000
Less O&M Cost $                           30,000 $                  40,000 $                 50,000 $             60,000
Less Depreciation $                         149,985 $                200,025 $                 66,645 $             33,345
Less Interest on loan $                           20,000                       13,958                       7,311
EBT $                         (19,985) $                 (53,983) $                 96,044 $           146,655
Tax @35% $                           (6,995) $                 (18,894) $                 33,615 $             51,329
PAT $                         (12,990) $                 (35,089) $                 62,428 $             95,326
Add Back depreciation $                           20,000 $                  13,958 $                   7,311 $                      -  
Total After Tax cash flow from Operations $                             7,010 $                 (21,131) $                 69,740 $             95,326
Cash flow from Salvage -Afer Tax=90000*(1-35%)= 58500
Total After Tax cash flow : $                             7,010 $                (21,131) $                 69,740 $           153,826
Add a comment
Know the answer?
Add Answer to:
I need this solved step by step and by hand. Please no Excel. Thank You! 1...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • 7) (35 points) EmKay, Inc. is considering the purchase of new automated equipment to increase its...

    7) (35 points) EmKay, Inc. is considering the purchase of new automated equipment to increase its production capacity. For this purchase, the following data apply: Purchase price = $450,000 ($250,000 from own funds (equity) and $200,000 from a loan) Equipment Life: 4 years Depreciation: MACRS-GDS 3-year property Estimated salvage: $90,000 Effective tax rate: 35% EOY Expected O&M Costs Estimated revenue $30,000 $180,000 2 $40,000 $200,000 3 $50,000 $220,000 4 $60,000 $240,000 Conditions on loan: $200,000 borrowed at a nominal rate...

  • I need this solved step by by step please by hand. Please no Excel. Thank You!...

    I need this solved step by by step please by hand. Please no Excel. Thank You! 6) (28 points) A company is considering a replacement for an aging machine that has been fully depreciated for tax purposes. The new machine will have an initial cost of $400,000 and is expected to generate an income of $125,000 per year. Its estimated salvage value at the end of its useful life of 4 years will be $60,000. The new machine is a...

  • 6) (28 points) A company is considering a replacement for an aging machine that has been...

    6) (28 points) A company is considering a replacement for an aging machine that has been fully depreciated for tax purposes. The new machine will have an initial cost of $400,000 and is expected to generate an income of $125,000 per year. Its estimated salvage value at the end of its useful life of 4 years will be $60,000. The new machine is a MACRS-GDS 3-year property for calculating depreciation deductions. The effective tax rate is 35%. a) (20 points)...

  • 6) (28 points) A company is considering a replacement for an aging machine that has been...

    6) (28 points) A company is considering a replacement for an aging machine that has been fully depreciated for tax purposes. The new machine will have an initial cost of $400,000 and is expected to generate an income of $125,000 per year. Its estimated salvage value at the end of its useful life of 4 years will be $60,000. The new machine is a MACRS-GDS 3-year property for calculating depreciation deductions. The effective tax rate is 35%. a) (20 points)...

  • Please answer part B. Part A is correct. Will rate highly. A company purchases an industrial laser for $153,000. The de...

    Please answer part B. Part A is correct. Will rate highly. A company purchases an industrial laser for $153,000. The device has a useful life of 4 years and a salvage value (market value) at the end of those four years of $50,000. The before-tax cash flow is estimated to be s80,000 per vear. a. You, of course, suggested applying the 3-year MACRS (GDS) method instead of the straight-line method. Given b. Based on the MACRS depreciation schedule for this...

  • Answer part B, part A is correct estimated to be A company purchases an industrial laser for $153,000. The device has a...

    Answer part B, part A is correct estimated to be A company purchases an industrial laser for $153,000. The device has a useful life of 4 years and a salvage value (market value) at the end of those four years of $50,000. The before-tax cash flow V per y Ogested applving the 3-vear MACRS (GDS) method instead of the straight-line method. Given an effective tax rate of 25% , determine the depreciation schedule and the after tax cash flow b....

  • need help on this. Thank You. Homework: Chapter 7 - Depreciation & After-Tax Analysis Save Score:...

    need help on this. Thank You. Homework: Chapter 7 - Depreciation & After-Tax Analysis Save Score: 0 of 1 pt 5 of 7 (0 complete) HW Score: 0%, 0 of 7 pts Problem 7-19 (algorithmic) Question Help A company purchases an industrial laser for $123,000. The device has a useful life of 4 years and a salvage value (market value) at the end of those four years of $60,000. The before-tax cash flow is estimated to be $90,000 per year....

  • 1. An injection mokding machine can be purchased and installed for $80,000 It is in the...

    1. An injection mokding machine can be purchased and installed for $80,000 It is in the seven-year GDS property class and is expected to be kept in servioe for eight years. It is believed that $12,000 can be obtained when the machine is disposed of at the end of year eight. The net annual value added (i.e, revenues less expenses) that can be attributed to this machine is constant over eight years and amounts to $15,000, An effective income tax...

  • Engineering Economy Please solve, for A and B please solve them correct! A company purchases an industrial laser fo...

    Engineering Economy Please solve, for A and B please solve them correct! A company purchases an industrial laser for $176,000. The device has a useful life of 4 years and a salvage value (market value) at the end of those four years of $50,000. The before-tax cash flow is estimated to be $95,000 per year. a. You, of course, suggested applying the 3-year MACRS (GDS) method instead of the straight-line method. Given an effective tax rate of 28%, determine the...

  • The answer is already given, I just don't understand how. Can you please show how each...

    The answer is already given, I just don't understand how. Can you please show how each value is caculated and label please! 2. Depreciation, taxes and source of finance. Compute the present value of a project with the following characteristics: Initial investment required 1 million dollars, 40% of it will be financed with a loan at 10% interest rate payable yearly in five years. Yearly savings for the first year of the project is $300,000, increasing by 50,000 year after...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT