Question

Table A-1. 3-, 5-, 7-, 10-, 15-, and 20-Year Property Half-Year Convention Depreciation rate for recovery period Year 3-yearQuestion 4 (40 points): Calculate the After-Tax Cash Flow, ROR, and NPV (at minimum ROR = 12.5%, after tax) for the following

0 0
Add a comment Improve this question Transcribed image text
Answer #1
Year 0 1 2 3 4 5 6
1.Cost of Mineral rights acquisition -2500000
2.Intangible drilling cost -15000000
3.Tangible Equipment cost -10000000
4.NWC -1500000 1500000
Production of oil in no.of Barrels 500000 500000 500000 500000 500000 500000
Sale price/barrel 61.2 62.424 63.67248 64.94593 66.24485 67.56975
Total prodn. value 30600000 31212000 31836240 32472965 33122424 33784873
Operating cost -2100000 -2205000 -2315250 -2431013 -2552563 -2680191
Environmental OPEX(2000000*1.05^6) -2680191
Royalty(12.5%*Prodn. Value) -3825000 -3901500 -3979530 -4059121 -4140303 -4223109
Depletion costs -416667 -416667 -416667 -416667 -416667 -416667
Eqpt. Depn.(10000000*20%;32%;19.2%;11.52%;11.52%,5.76% -2000000 -3200000 -1920000 -1152000 -1152000 -576000
5. EBT 22258333 21488833 23204793 24414165 24860891 23208714
6. Tax at 21% -4674250 -4512655 -4873007 -5126975 -5220787 -4873830
7.EAT 17584083 16976178 18331787 19287190 19640104 18334884
8. Add back:Depln.& depn. 2416667 3616667 2336667 1568667 1568667 992666.7
9. ATCF 20000750 20592845 20668453 20855857 21208771 19327551
10.Total annual ATCFs(1+2+3+4+9) -29000000 20000750 20592845 20668453 20855857 21208771 20827551
11.PV F at 12.5%(1/1.125^Yr.n) 1 0.88889 0.79012 0.70233 0.62430 0.55493 0.49327
12. PV at 12.5%(10*11) -29000000 17778444 16270890 14516115 13020209 11769361 10273610
13.NPV(Sum of Row 12) 54628630
14. IRR(of row 10) 67%
IRR is the ROR
Add a comment
Know the answer?
Add Answer to:
Table A-1. 3-, 5-, 7-, 10-, 15-, and 20-Year Property Half-Year Convention Depreciation rate for recovery...
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
  • I am.handicap student please help fast nt seles Table A-1. 3-, 5-, 7-, 10-, 15-, and 20-Year Property Half-Year Convention Depreciation rate for recovery period Year 3-year5-year 7-year 10-yea...

    I am.handicap student please help fast nt seles Table A-1. 3-, 5-, 7-, 10-, 15-, and 20-Year Property Half-Year Convention Depreciation rate for recovery period Year 3-year5-year 7-year 10-year 15-year 20-year 33.33%| 20.00% | 14.29% | 10.00% | 5.00% | 3.750% 44.45 14.81 7.219 9.50 8.55 7.70 6.93 24.49 17.49 18.00 14.40 12.49 11.52 32.00 19.20 11.52 11.52 2 6.677 7.41 5.713 9.22 8.93 5 5.285 4.888 4.522 4.462 4.461 6.23 5.90 5.90 5.91 5.90 7.37 6.55 6.55 6.56 6.55...

  • Question 3 (10 points): Using the Modified Accelerated Cost Recovery method (table A-1), calculate the depreciation...

    Question 3 (10 points): Using the Modified Accelerated Cost Recovery method (table A-1), calculate the depreciation of $2,500,000 property for 7-year half -year convention. Note: you just need to calculate the depreciation; you do not need to use it in any further calculations. Table A-1. 3-, 5-, 7-, 10-, 15-, and 20-Year Property Half-Year Convention Depreciation rate for recovery period Year 3-year 5-year 7-year 10-year 15-year 20-year 33.33% 44.45 14.81 20.00% 32.00 19.20 11.52 11.52 14.29% 24.49 17.49 12.49 8.93...

  • THIS IS BASED ON 5 YEAR DEPRECIATION. 2. In plain English, explain how depreciation was calculated...

    THIS IS BASED ON 5 YEAR DEPRECIATION. 2. In plain English, explain how depreciation was calculated for years 1-3. 3)In plain English, explain how depreciation was calculating for years 4-6 Table A-1. 3-, 5-, 7-, 10-, 15-, and 20-Year Property Half-Year Convention Depreciation rate for recovery period Year 3-year 5-year 7-year 10-year 15-year 20-year 33.33% 44.45 14.81 7.41 20.00% 32.00 19.20 14.29% 24.49 17.49 12.49 8.93 10.00% 18.00 14.40 11.52 9.22 5.00% 9.50 8.55 7.70 6.93 3.750% 7.219 6.677 6.177...

  • In plain English, explain how depreciation was calculated for years 1-3, for the 5-year column 3....

    In plain English, explain how depreciation was calculated for years 1-3, for the 5-year column 3. In plain English, explain how depreciation was calculating for years 4-6 (Hint: See MACRS4 solution, end-of-year basis for year 3; divide by 5, but you must explain why you divided by 5). Depreciation rate for recovery period Year 3-year 10-year 20-year 5-year 7-year 15-year 20.00% 14.29% 10.00% 5.00% 3.750% 33.33% 24.49 18.00 9.50 7.219 44.45 32.00 14.81 19.20 17.49 14.40 8.55 6.677 3 4...

  • Clay LLC placed in service machinery and equipment (seven-year property) with a basis of $3,462,500 on...

    Clay LLC placed in service machinery and equipment (seven-year property) with a basis of $3,462,500 on June 6, 2019. Assume that Clay has sufficient income to avoid any limitations. Calculate the maximum depreciation expense including $179 expensing (ignoring any possible bonus depreciation). (Use MACRS Table 1) (Round final answer to the nearest whole number.) Multiple Choice $494,791 $1,011073 $459,430. None of the choices are correct $686.930 Table 1 MACRS Half-Year Convention 20-Year Year 1 3.750% Year 2 7.219 Depreciation Rate...

  • Please refer to IRS Publication 946 2. In plain English, explain how depreciation was calculated for...

    Please refer to IRS Publication 946 2. In plain English, explain how depreciation was calculated for years 1-3. 3. In plain English, explain how depreciation was calculating for years 4-6 (Hint: See MACRS4 solution, end-of-year basis for year 3; divide by 5, but you must explain why you divided by 5). 4. Additional comments (optional): Table A-1. 3-, 5-, 7-, 10-, 15-, and 20-Year Property Half-Year Convention Depreciation rate for recovery period 3-year 5-year 7-year 10-year 15-year Year 20-year 33.33%...

  • Arlington LLC purchased an automobile for $62,000 on July 5, 2018. What is Arlington's depreciation expense...

    Arlington LLC purchased an automobile for $62,000 on July 5, 2018. What is Arlington's depreciation expense for 2018 if ts business use percentage is 61 percent (ignore any possible bonus depreciation)? (Use MACRS Table 1, and Exhibit 10-10) Multiple Choice $6,200 $6,100. $4,775 $9,300 None of the choices are correct. TABLE 1 MACRS Half-Year Convention Depreciation Rate for Recovery Period 7-Year 14.29% 24.49 17.49 12.49 8.93 8.92 8.93 4.46 Year 3-Year 5-Year 10-Year 1 5-Year 20-Year 33.33% 44.45 14.81 7.41...

  • Arlington LLC purchased an automobile for $80,000 on July 5, 2018. What is Arlington's depreciation expense...

    Arlington LLC purchased an automobile for $80,000 on July 5, 2018. What is Arlington's depreciation expense for 2018 if its business use percentage is 80 percent (ignore any possible bonus depreciation)? (Use MACRS Table 1, and Exhibit 10-10.) Multiple Choice None of the choices are correct. $12,000. $6,125. $8,000. $8,000. TABLE 1 MACRS Half-Year Convention Depreciation Rate for Recovery Period Year 3-Year 5-Year 10-Year 15-Year 20-Year 20.00% 32.00 19.20 11.52 11.52 5.76 7-Year 14.29% 24.49 17.49 12.49 8.93 8.92 8.93...

  • 83 Reid acquired two assets in 2019: on August 6th he acquired computer equipment (five-year property)...

    83 Reid acquired two assets in 2019: on August 6th he acquired computer equipment (five-year property) with a basis of $1,020,000 and on November 9th he acquired machinery (seven-year property) with a basis of $1,020,000. Assume that Reld has sufficient income to avoid any limitations. Calculate the maximum depreciation deduction, including 5179 expensing (but not bonus depreciation). (Use MACRS Tab .) points Essay Toolbar navigation ( 01:07:02 BI V SE 11. A A 7.70 Table 1 MACRS Half-Year Convention Depreciation...

  • On April 5, 2019, Kinsey places in service a new passenger automobile that cost $60,000. The...

    On April 5, 2019, Kinsey places in service a new passenger automobile that cost $60,000. The car is used 100% for business in each tax year. Kinsey uses the MACRS 200% declining-balance method of cost recovery (the auto is a 5-year asset). Assume Kinsey elects any available additional first-year depreciation. The maximum depreciation allowed for 2019 is $ 12000 X and for 2020 is S 16000 20 5 Hint(s) EXHIBIT 8.4 MACRS Accelerated Depreciation for Personal Property Assuming Half-Year Convention...

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