Budget-Tyler+Vanderhoof

‍‍‍‍

‍ ‍This project in Excel is a sample budget I have created for my friend. It uses estimated, but close, figures for his income and expenses. Several named functions are used, including PMT and SUM, as well as simple functions. The IF function us used along with conditional formatting in the cell showing the disposable income. If this figure is positive, the cell is highlighted green, but if it is negative it is highlighted red. I also included figures showing how much interest he can earn by putting his extra money into a savings account. A pie chart is also included which summarizes the relative percentages of each of my friend's expenses.‍ ‍

almeidaa5 Comment: You have done an excellent job with this. You were able to use functions to get your situation across. Your ability to use a pie chart was very helpful as well. Great job!