Answer:
Future value in year 14 of the royalty income is $91,603.32.
Explanation:
Note: See the attached excel for the calculation of the future value in year 14 of the royalty income from the wells.
In attached excel file, the royalties received per year from year 7 is calculated using the following formula:
Current Year Royalties Received = Previous Year Royalties Receive * (100% - Yearly Decreasing Rate) = Previous Year Royalties Receive * (100% - 15%).
From the attached excel file, future value in year 14 of the royalty income (in bold bold red color) is $91,603.32.