Advanced Excel project with ability to provide various assumptions & scenarios

Three partners currently under mediation from 1st Oct 2020 for the quarterly amount they received through contract since March 2011. Contract is expected to go till June 2030.

Outcome of this exercise is for partners understanding when they mediate, what impact they will have on their share / backpay based on different percentage scenarios. They should be able to easily understand $ value when changing % values. we will do as current percentages, however ability to amend percentages should be there, which will then show change in $$ values.

Currently Sam receives 30% of the contract value, Chris receives 69.5% and John receives 0.5%. Sam and Chris have a major dispute while John is not fussed but maybe wants little increase.

Based on Financial impact summary, we need to add total amount received by Sam till Sept 2020 (which is $30,377,520.30) as per 30% and then work out total amount received for Chris and John based on their percentages. Partners will choose whether they would prefer to pay lumpsum or pay from their future payments, so we need to account for those options in building formula and work out NPV if they prefer to pay lump rather then from future payments which will go on till June 2030.

For future payments assumption from Dec 2020 to June 2030, we will assume contract payment to remain same for 2 years, then to be 90% for other 2 years, 80% for 2 years after that, 70% for next two years and last year at 60%.

We are thinking total 4 tabs for this assignment.

First: Financial Summary (linking all tabs into this one including back and future payments)

Second: Assumptions

Looking Back: summary table including NPV (2011 to Sept 2020). Partners will have a option to pay lumpsum to each other or deduct $$ from their future payments to compensate another partner. So, working our NPV is very important

Looking Forward: straight forward based on outcome of mediation. we will still need to create one with assumptions based on decrease % as mentioned above.

Skills: Excel, Finance, Accounting, Data Entry, Statistics

See more: excel scenario manager multiple sheets, scenario manager excel 2019, excel scenario modeling, scenario manager excel, scenario analysis excel template, dynamic scenario analysis excel, how to create a scenario summary report in excel, scenario manager excel 2016, b2b project can provide outbound process, simple excel project grade, excel project manage template web design, excel project task list, visual studio excel project, excel project help needed, advanced excel mortgage spreadsheet, excel project macro samples, peachtree excel project, excel project bid template, quick excel project, creating simple excel project

About the Employer:
( 0 reviews ) Nhulunbuy, Australia

Project ID: #27390071

Awarded to:


Hello Let me introduce myself. I am a Chartered Accountant with over 5 years of experience in the fields of Accounting, Finance, Taxation and corporate affairs. I can share some of my work with you before we start. L More

$150 AUD in 7 days
(8 Reviews)

5 freelancers are bidding on average $124 for this job


Hi there, I am an expert in excel formulas, dashboards, macros. I have gone through the description on your project and will be able to finish in few hours. Thanks Arun

$110 AUD in 2 days
(5 Reviews)

Hello, My name is Karolis and i would like to let you know that i'm a very hardworking and dedicated person, i only take payment when my client's smile on my output i will do my work with full honesty. i am a new fre More

$100 AUD in 3 days
(0 Reviews)

Hello, My name is Michael i would like to let you know that i'm a very hardworking and dedicated person, i only take payment when my client's smile on my output i will do my work with full honesty. i am a new freelance More

$140 AUD in 7 days
(0 Reviews)

My name is Akbar Ahmed. I am a specialist of data entry with an experience of five years. I have experience of proven data entry work, MS office, data programs and I am acquainted with administrative duties. Also, I h More

$122 AUD in 6 days
(0 Reviews)