Create Net Worth and Cashflow Statement with interlinked Dashboards in Pivot Table Excel

The task is to adjust the attached sample excel file in a way that there is one dashboard which displays the current net worth as well as the net worth development over time. Furthermore average monthly net worth growth need to be shown (enable/disable). For this purpose current monthly date minus previous monthly date needs to be calculated to come up with the average net growth equalized over a 30 day month period. (some values are entered e.g. on the 15 of July next month values are entered on the 1st of August. Therefore use average value to calculate monthly net worth growth) On the same dashboard the cashflow needs to be displayed as well as projected future cashflow development included to see future net growth development (enable/disable). Assets and Liabilities as well as cash flow link to the dashboard. Values in Dashboard need to be shown in absolute money values as well as in %. Assets, Liabilities and Cashflow are in various currencies. The individual values need to be input in the foreign currency and for each month a fx rate needs to be input so that the final numbers are displayed in one single unified currency (EUR) one time input per month and used throughout the whole workbook. The exchange rate needs to be entered for each month in order to show the respective value in EUR for each month. Finally provide workbook in visually appealing layout. Payment is in 3 milestones Milestone 1= 30% down payment upon award project Milestone 2= 40% payment after overall completion of project Milestone 3= 30% payment after final hand over of fully workable and customized file in visually appealing layout. PLEASE PUT “***HAPPY***” IN YOUR BID IN ORDER TO BE CONSIDER AND THAT I CAN SEE YOU ACTUALLY READ AND UNDERSTOOD THE PROJECT