oh, dang, no, overlooked the second column, ok, I'm not even sure what it's measuring, as it's pulling the numbers from the Expenses sheet, but so is the summary so they should always end up being the same number. Similar issue for the Bills / Expenses, Savings, Flex Spending section below that table, I'm not even sure why it needs such a long calculation when it can just sum the totals over on the left. I don't think it recognises 'ThisRow', but just using $ works fine, as far as I can tell? (This may be a LibreOffice problem): None of the values in Table 4 ('how much should I spend on.?') calculate for me unless I replace the ]] with *$F5 (where f5 = the cell with the % in that row). I've kinda put this together amongst my work, so not taking any responsibility for accuracy, this was more of a fun side project.įeel free to play around with it and let me know of any bugs or feedback you might find.Ĭan't read any text under the 'Household Income' section (it's black on black), only noticed there was text because of the red underline under "Semi Annuall". If monthly, it'll give you the monthly figure. So if you're paid weekly, it should give you a weekly expenses/budget. I've tried my best to try and match the savings figures to what your pay frequency is at. ![]() You've now got the option to put in your figure and then advise whether it's weekly/monthly/fortnightly figure and the sheet will do the rest. I also thought it was a bit stupid that the expenses were required to be put in monthly, so things like WOF's or Weekly Rent, or a fortnightly mortgage would need to be calculated before putting in. I've also touched up the American formulas, because I found everything of his was budgeted on a semi-monthly pay (1st and 15th every month), so I've made it a little more user friendly that it now matches to your pay frequency (Weekly/Fortnightly/Semi-Monthly/Monthly). I've modelled the taxcodes on the PAYE calculator found at : I've basically ripped the guts out of this and had a bit of a play around with some of the formulas.įeel free to give any commentary, I can't garuntee the accuracy on this, nor on any of the figures quoted throughout. ![]() Related SubredditsĪ couple of days someone asked for a New Zealand specific budgeting spreadsheet as per the one in /r/personalfinance. ![]() ![]() If you need to find a registered financial adviser, IFA have a search function here. Note: Nothing in this subreddit is licensed advice. Learn how to better manage your money and debt, how to save an emergency fund, and how to ensure your financial future is secure.īefore posting, check out the wiki to see if your question has already been answered! Totally confused when people start talking about their 401k, student loan interest, filing tax jointly, or any other terms that don't apply in New Zealand? /r/PersonalFinanceNZ is a spot to talk about savings and investments, KiwiSaver, debt management, home loans, student loans, insurance, and anything else you want to talk about. Subreddit Rules Subreddit Discord Message Moderators About
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |