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 |
Table A-1. 3-, 5-, 7-, 10-, 15-, and 20-Year Property Half-Year Convention Depreciation rate for recovery...
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 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 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 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 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 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 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 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) 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 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...