I can do this for you. Did you merely want an Excel spreadsheet that contains the relevant data and summarizes annual taxes, net income, etc.?
I don't see how "future/present value" has anything to do with anything. There are no depreciating assets here--unless we consider Andrew Luck himself to be the depreciating asset! (Let's put it this way: there are no depreciating assets that can readily be modeled in closed form.)
Please advise, and I'll get right to work.
Since that attachment has nothing to do with Andrew Luck's contract situation, I shall ignore it completely and implement the specs precisely as dictated by the "Messages" box above.
All required fields have been implemented. All boxes are neatly formatted and have borders. INCOMES and ASSETS are indicated in (light) green; DEBITS and EXPENDITURES are indicated in (light) red, that is, pink.
Federal and state taxes can be entered via drop-down boxes. Click on the cells immediately to the right of "Enter federal tax:" and "& state tax:" and choose from the values in the dropdown menu. Those values are populated from cells N13:O21, which do not appear in the window until scrolled to. Please do not modify these lists for fear of breaking the formulas in other cells: just ask for any requested updates, such as, "I need state tax rates of 4.2%, 6.6%, and 11.3%."
Cell formulas are duplicated as appropriate from cell to cell.
Please see attached output file for completed task. Thank you for your patience.
In fact, here's a slight formatting change: EVERY spreadsheet deserves a bold title!
Thank you for your forbearance.
This wasn't specified in the task. There was no mention of sheet one or sheet two, merely of Andrew Luck's contract. Your attachment says nothing about that whatsoever. See the message stream above. I don't mind doing extra work, but it requires an adjustment to the scope. If you want a second project, I'm afraid you have to set that up. I don't make the rules, I only live by them!
Furthermore, the three additional analyses can all fit on one sheet. It would be needless complication--as well as entirely non-standard practice--to relegate three affine analyses to three disparate worksheets instead of displaying them in independent sections of a single worksheet.
I wouldn't steer you wrong. Accountants just don't do that. Three-year, five-year, and ten-year projections are just birds of a feather, not three independent analyses. They just require some extra rows, and maybe a few adjustments to cell background colors, like, ultra-light yellow, not-quite-so-light yellow, and semi-pale yellow.
I see, as you said above, that "this is good." However, you have complained that it "only completes sheet 1," which, of course, was the only problem requested when you posted the task.
I would appreciate your indication of "answer accepted" before trying to past-post three additional tasks. An offer was extended to you to cover the time and effort of the three additional tasks that suddenly materialized, but JustAnswer has not received your response thereto.
Thank you for your cooperation.