I am at present working on the attached sheet I have received from my manager. This sheet is all about availing the loan and then making the investment to generate the revenue out of it.
The sheet should be reformatted to represent the data in a much better way that is easy to understand.
I would need the following graphs against each month:
1."Amount of Interest Payable" and "Total Payable"
2. "Amount Paid" and "Accumulated Payments"
3. "Revenue Generated", "Net Profit" and "Accumulated Net Profit"
The graphs can be a bar chart. For example for the third graph, there will be three adjacent bars standing against for a month.
I am open for the suggestions that makes this sheet presentable in a better way.
Appreciate your help on this.