The Lifestyle Planner by Miss Invest 3.0 - 02-Jul-2021
The Lifestyle Planner by Miss Invest 3.0 - 02-Jul-2021
The Lifestyle Planner by Miss Invest 3.0 - 02-Jul-2021
LIFESTYLE PLANNING WORKSHEET - Input your assets/liabilities. If there is none, type in zero on all gray cells.
- Savings Ratio = % of running income this year that you have saved.
- Debt-to-asset Ratio = % of your assets financed by debt
Engr. Lovely Charmaine R. Gomez - Liquidity Ratio =% of your net worth allocated to cash or cash equivalents; you can cash out within a month
Licensed Financial Advisor | Chemical Engineer | Content Creator
Connect with me: beacons.page/MissInvest
Inflation Rate: 4.20%
0908 897 5640 | [email protected]
BALANCE SHEET
TOTAL ASSETS ₱ - TOTAL LIABILITIES ₱ -
Cash Equivalents ₱ - Properties ₱ - Current Liabilities ₱ - NET WORTH
Cash ₱ - Residence ₱ - Credit Card 1 ₱ -
Checking Account ₱ - Car ₱ - Credit Card 2 ₱ -
Savings Account ₱ - Jewelry ₱ - Credit Card 3
Money Market ₱ - Artworks ₱ - Banko de Mama
Others ₱ - Others ₱ - Banko de Papa
Investments ₱ - Non-current Assets ₱ - Non-current Liabilities ₱ - Savings Ratio 0.00%
Individual Stocks ₱ - Housing Mortgage ₱ - Mortgage Balance ₱ - Debt-to-Asset Ratio #DIV/0!
Forex ₱ - Car Loan ₱ - Car Loan Balance ₱ - Liquidity Ratio #DIV/0!
Crypto ₱ - VUL Fund Value ₱ -
Indices ₱ - Endowment Benefit ₱ -
Others ₱ -
MONTHLY LIFESTYLE PLANNER
✓ Dotted/pink cells are editable
Engr. Lovely Charmaine Gomez ✓ Make sure to fill in ALL cells under each monthly expense; if there is no allocation, put "0" on all cells.
Licensed Financial Advisor | Chemical Engineer | Content Creator ✓ If the YTD cell is full red, this means you have maximized your spending. If it's full green, this means you are saving more than the minimum requirement.
✓ Needs = Necessities, Savings = LTSS + Financial Freedom, Wants = Education + Play + Give
fb.com/MissInvest | instagram.com/Miss.Invest | tiktok.com/@missinvest | [email protected]
YTD Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Projected Net Income ₱ 360,000 ₱ 30,000 ₱ 30,000 ₱ 30,000 ₱ 30,000 ₱ 30,000 ₱ 30,000 ₱ 30,000 ₱ 30,000 ₱ 30,000 ₱ 30,000 ₱ 30,000 ₱ 30,000
Salary ₱ 360,000 ₱ 30,000 ₱ 30,000 ₱ 30,000 ₱ 30,000 ₱ 30,000 ₱ 30,000 ₱ 30,000 ₱ 30,000 ₱ 30,000 ₱ 30,000 ₱ 30,000 ₱ 30,000
Side Hustle A ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ -
Side Hustle B ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ -
Business ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ -
Allowances ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ -
Receivables ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ -
Others ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ -
55% Necessities ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ -
Food/Groceries ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ -
Rent/Mortgage ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ -
Transportation ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ -
Water ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ -
Electricity ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ -
Credit Card ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ -
Phone Bill ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ -
Internet ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ -
Insurance ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ -
Loan Payables ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ -
10% Play ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ -
Clothes ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ -
Shoes ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ -
Bags/Accessories ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ -
Dining out ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ -
NetFlix ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ -
Entertainment ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ -
Subscriptions ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ -
Others ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ -
10% Education ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ -
Books ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ -
Training/Worshops ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ -
Mentoring/Coaching ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ -
5% Give ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ -
Family Contribution ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ -
Tithes/Charity ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ -
Gifts ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ -
Total Budget ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ -
Needs ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ -
Savings ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ -
Wants ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ -
Free Money for Savings ₱ 360,000 ₱ 30,000 ₱ 30,000 ₱ 30,000 ₱ 30,000 ₱ 30,000 ₱ 30,000 ₱ 30,000 ₱ 30,000 ₱ 30,000 ₱ 30,000 ₱ 30,000 ₱ 30,000
Under/(Over) spending on Wants ₱ 90,000 ₱ 7,500 ₱ 7,500 ₱ 7,500 ₱ 7,500 ₱ 7,500 ₱ 7,500 ₱ 7,500 ₱ 7,500 ₱ 7,500 ₱ 7,500 ₱ 7,500 ₱ 7,500
₱35,000
₱30,000
₱25,000
₱20,000
₱15,000
₱10,000
₱5,000
₱-
J an F eb Mar Apr May Jun Jul Aug Sep Oct No v D ec
YTD Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Projected Net Income ₱ 360,000 ₱ 30,000 ₱ 30,000 ₱ 30,000 ₱ 30,000 ₱ 30,000 ₱ 30,000 ₱ 30,000 ₱ 30,000 ₱ 30,000 ₱ 30,000 ₱ 30,000 ₱ 30,000
Salary ₱ 360,000 ₱ 30,000 ₱ 30,000 ₱ 30,000 ₱ 30,000 ₱ 30,000 ₱ 30,000 ₱ 30,000 ₱ 30,000 ₱ 30,000 ₱ 30,000 ₱ 30,000 ₱ 30,000
Side Hustle A ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ -
Side Hustle B ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ -
Business ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ -
Allowances ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ -
Receivables ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ -
Others ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ -
55% Necessities ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ -
Food/Groceries ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ -
Rent/Mortgage ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ -
Transportation ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ -
Water ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ -
Electricity ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ -
Credit Card ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ -
Phone Bill ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ -
Internet ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ -
Insurance ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ -
Loan Payables ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ -
10% Play ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ -
Clothes ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ -
Shoes ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ -
Bags/Accessories ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ -
Dining out ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ -
NetFlix ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ -
Entertainment ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ -
Subscriptions ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ -
Others ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ -
10% Education ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ -
Books ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ -
Training/Worshops ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ -
Mentoring/Coaching ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ -
5% Give ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ -
Family Contribution ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ -
Tithes/Charity ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ -
Gifts ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ -
Total Spending ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ -
Needs ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ -
Savings ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ -
Wants ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ - ₱ -
Free Money for Savings ₱ 360,000 ₱ 30,000 ₱ 30,000 ₱ 30,000 ₱ 30,000 ₱ 30,000 ₱ 30,000 ₱ 30,000 ₱ 30,000 ₱ 30,000 ₱ 30,000 ₱ 30,000 ₱ 30,000
Under/(Over) spending on Wants ₱ 90,000 ₱ 7,500 ₱ 7,500 ₱ 7,500 ₱ 7,500 ₱ 7,500 ₱ 7,500 ₱ 7,500 ₱ 7,500 ₱ 7,500 ₱ 7,500 ₱ 7,500 ₱ 7,500
₱35,000
₱30,000
₱25,000
₱20,000
₱15,000
₱10,000
₱5,000
₱-
Jan Feb Mar Ap r May Jun Jul Au g S ep Oc t Nov D ec
YOUR LIFESTYLE
MAGIC NUMBER
TOTAL ₱15,000.00 You need:
➤
This is the future value of your current Needs and
Limit ₱18,000.00
Unused Allocation ₱3,000.00
Wants starting from retirement until 80y.o.
(e.g. If you retire at 60 y.o.; this amount will sustain (₱14,244,513)
you for 20 years or from age 60 - 80)
Excess Spending ₱0.00 to afford the same Needs & Wants during retirement.
-59352.14
YOUR CASH FLOW
➤
You need to save:
Needs 25.00% AT RISK This is how much you need to save monthly starting
Notes
Nagulat ka rin ba sa laki ng Magic Number mo? That's what inflation does.
What do I suggest? Don't save now. Postpone savings for later. But remember, the more you delay, the larger the amount you would need to save in the future.