MATH

I still see that you are missing your Total 5 Year Budget Projection formula at the veryyyyy top of your spreadsheet on the expenses part. This should be your =((F6+F7+F11+F12+F16+F21+F22+F23)*(1+L8)) which should actually equal $27,639.96 if I’m not mistaken. Correct me if I am wrong. This then changes your amounts for the second part of the worksheet. So, for the principal just change your 30,000 to the above number I said (as long as you clarify it is correct).Your total in five years for your sponsorship should actually be =C4*((1+C5/C6)^(C6*C7)) so you just forgot the /C6.Total in five years for your fundraising should be =F4*((1+F5/F6)^(F6*F7)-1)/(F5/F6).**These formulas are posted from the professor**Your principal amounts for plan A and B should actually be the same. This is going to be =D3-D8-F8 for both. You want to know how much money you still need to loan after having your budget, getting money from the sponsorship, and then fundraising as well.Your total number of years for your loans need to be different. For example I did one for two years and one for three years.Your payment formula should be =I4*(I5/I6)/(1-(1+I5/I6)^(-I6*I7)) and same for your other one just with K.Interest paid should be =I6*I7*I8Your total interest paid should be I10-I4.