Debt vs Equity: What are the pros and cons of raising equity? | Josh Aharonoff, CPA posted on the topic | LinkedIn (2024)

The 52 Card Deck of Finance & Accounting 🃏Pick up a card and learn something new each time!There is a never ending list of things you need to know if you want to become a CFO…What better way to learn while having fun with the family?👍 Give this post a like if you want me to produce this deck of cards!Here’s what’s included:❤️ ACCOUNTINGLearn the fundamentals of Accounting, the language of business!Master key terms such as:• Cash vs Accrual• Balance Sheet• Bank Reconciliations• General Ledger• Gross Profit• Profit & Lossand more…♠️ FINANCIAL PLANNING & ANALYSIS (FP&A)FP&A is my favorite area of Finance & Accounting, and once you’re done with these cards, it will be yours too!Learn all about FP&A, including key terms such as:• Budget• Forecast• Planning• Varianceand much more…🔸 FINANCELooking to get a loan? Value a business? Work in investment banking?Then you’ll love these cards…Get familiar with many terms such as:• Discounted Cash Flows• Free Cash Flows• Net Present Value• Return on Invested CapitalAnd more!♣️ AUDIT / TAXIf you’re thinking of joining public accounting…you’ll need to know about Audit and Taxand if you’re not…odds are you’ll still need to know these termsBecome a pro at auditing with key terms such as:• Statistical Sampling• Qualified Opinion• Going concernAnd become a tax expert by picking up these cards:• Income Tax• Sales Tax• Filing Extension===I had a lot of fun putting this one together, and hope you enjoy playing with the 52 card deck of Finance & Accounting!What are some other Finance & Accounting terms you’d add to this deck?Let us know in the comments below 👇PS: If you’d like to get a copy of this deck of cards, give this post a like and let me know in the comments below...if enough people ask, I’ll get it produced!

231

23 Comments

The CFO Tech Stack 🙌After working with 100+ companies in my career…I’ve been exposed to TONS of tools.These tools are vital in helping us:→ work efficiently→ reduce errors→ reduce costs→ save timeHere’s an overview of what each of these tools do➡️ ACCOUNTING SOFTWAREThis can be a traditional accounting software….or a full fledged ERPThe idea is that instead of utilizing a spreadsheet, you have the power to leverage:→ automatic bank feeds→ integrated & dynamic reporting→ bank reconciliationsand so so much more➡️ AP PlatformAlmost every company has bills to pay…and many are still processing them manually from their bank…or worse…via check 🤮An AP platform is crucial, allowing you to:→ upload bills right from your inbox→ categorize & sync bills to your accounting software→ collect the necessary approvals→ process payments directly from one platform➡️ Payroll & HRISWe’ve come a long way with payroll.No one does this by hand anymore - everyone uses some form of a payroll company.That payroll company helps you:→ onboard new employees→ process paychecks, with withholding taxes→ remain in compliance➡️Expense Reimbursem*ntsPeople are always spending money on their personal cards…it’s a popular way to rack up points.Expense reimbursem*nt softwares make it easy for you to manage the repayments, allowing you to:→ upload receipts→ generate expense reports→ process payments➡️ Payments & Credit CardsInstead of dealing with the headache of expense reimbursem*nts…why not give your employees a virtual credit card?With virtual credit cards you can:→ create a card→ set a limit→ destroy a card→ control which vendor they can payall in a matter of seconds.This is one of my favorite tools in this list➡️ Tax & LegalTaxes are notorious for being complicated and difficult to file.The same holds true for legal matters…which is a common aspect of your cap tableI love working with tools that allows me to stay in compliance..without having to read up on all the legalities 🧐➡️ Revenue & Contract MgmtGot 40+ customers? Don’t make the mistake of managing that all in excel.Sure, Excel is my favorite tool on this list…but you need something much more robust.Something that can:→ calculate various metrics (MRR, NDR, CAC etc.)→ manage contract changes, both retroactively and prospectively→ calculate revenue & deferred revenue➡️ Banking & TreasuryWe all remember what happened earlier last year with SVB…but thankfully, they aren’t the only ones providing banking solutions.I’m a much bigger fan of using a well known bank as opposed to a regional bank…as the bigger guys have a lot of integrations & easy to use platforms, which is key for scaling.===I have so much to comment on, but only have 3k characters.Got any tools that you think I missed? Let us know in the comments belowPS: Check out the comments below for my favorite tech stack 👇

340

48 Comments

Learn every Excel error…and how to resolve 👇Excel errors are really scary 😨 But with the right tools, you can debug even the biggest error in your excel file.Let's walk through each one and how to resolve:⚠️ ###This may be the easiest error…it simply means that the data cannot be displayed, because the column is too narrow.💡Resolution → extend the column⚠️#REF!This is a really popular error, and relates to when you have a range in a formula that can no longer be found…IE it was deleted💡Resolution → utilize the trace dependents button before deleting something⚠️ #DIV/0This is when you try and divide something by 0💡Resolution → trace the reference in the formula, and revise the denominator from 0.⚠️ #N/AThis one is similar to #REF!…only it’s in the context of lookups, and specifically whenever a match can’t be found💡Resolution →double check the lookup value in your formula to ensure it exists in your lookup range⚠️ #NAME?This is whenever you have a typo in your formula, or named range.💡Resolution → double check the spelling and ensure you’re using the right naming⚠️ #VALUE!This one is whenever you have an incorrect character in a formula or reference💡Resolution → refer back to the range where the data is contained, and remove any incorrect characters⚠️ #NULL!This error will show whenever you either have an incorrect data type of number format in a formula, or if excel can’t perform an excel calculation.A popular example here is when you try to take the square root of a negative number in excel.Similarly, you may come across this error when using IRR or RATE and no result can be found.💡Resolution → you can enable iterative calculations, just like you would with circular references.⚠️ #NUM!You may come across this error whenever you include a space in a formula instead of a : or a , between 2 arguments.The resolution is simple - replace the space with a colon or comma⚠️ #CALC!Here’s another one that you may not have come across…Array functions are those that return an array or results rather than a specific result. In this case, there’s no answer to return, so you’ll get this error.💡Resolution → double check your formula and ensure that your search value can be found⚠️ #SPILL!This one is pretty straight forward, and is reserved for when you try to utilize a spill function.More specifically, it’s when your spill function is blocked by a value, and the function can’t SPILL into other cells.💡Resolution → simply remove the values that are blocking the spill function.⚠️ #BLOCKED!This last one I actually never heard of, till one of my readers pointed it out - it’s when you don’t have the permissions to access data, such as a license, connection, or privacy setting.💡Resolution → check your permissions / licenses.===Is your Excel sheet wkbk now error free?Mission accomplished 🙌 Let me know which one you've seen before below 👇

406

27 Comments

Learn about Cash vs AccrualThese 2 methods are the foundation to financial reporting…and can result in wildly different figuresLet’s start with some definitions:➡️ What does Cash vs Accrual Mean?These 2 methods are ways in which you can report information on your financial statements.Each method follows a different set of rules, which can cause the data to mean something entirely different across each.➡️ CASH BasisUnder the Cash basis of accounting, money IN is treated as income, while money OUT is treated as expensesNote that while this is generally true, there are some exceptions:☝️Money IN can represent an expense refund (negative expense), or debt (which is a balance sheet item) to name a few…✌️Money OUT can represent a sales refund (reduction in sales), or inventory / fixed asset (which are balance sheet items) to name a few…➡️ ACCRUAL BasisUnder the Accrual basis of accounting, income is only recognized once it’s EARNED, while expenses are only recorded once they are INCURREDWhat does that mean?Earning income means you delivered your product or serviceIncurring expenses means you consumed something that had a cost …and this is where so many of the adjusting journal entries that are required each month are prepared such as1️⃣ Prepaids - causing you to amortize certain expenses paid upfront to be split over the the period in which it gets incurred2️⃣ Deferred Revenue - causing you to amortize income collected / invoiced upfront over the life of the contract3️⃣ Accruals - causing you to recognize certain expenses in the current period, even if the bill hasn’t been received, or the payment has been made🤔 So which method do I prefer?For small companies, the cash basis is great, as it simplifies much of your reportingAt the same time, larger companies almost always opt for the accrual basis of accounting, for the following reasons1️⃣ GAAP Requires AccrualWhile the IRS may allow companies up to a certain size to report under either method, GAAP requires you to reconcile under the accrual method.That can be especially relevant for the 2nd reason:2️⃣ Investors like to see what’s really happeningWhen you have outside investors, it’s common for them to want to see your financial statements under the accrual basisWhy?Because the accrual basis explains what’s really happening in the business, allowing you to make better sense on key KPIs & margins, and to forecast the futureSo in short:◾SMALL BUSINESSES without a heavy amount of outside capital can benefit from the SIMPLICITY of the CASH BASIS of accounting◾ LARGER BUSINESSES with a larger amount of outside capital are often required to record under the ACCRUAL basis===That’s my take on the Cash vs Accrual…but there’s much more to itWhat would you add?Join the discussion in the comments below 👇PS: We cover this topic, and much more in my course Accounting Made Easy🔗 https://lnkd.in/eNdDWx52

919

38 Comments

Learn 9 Ways to Forecast 👇Each time I build a forecast for a client, I work on first getting to know their business.I ask questions like…❔ How do you make money?❔ What are your plans for growth?❔ What is currently happening with your business?From there, I start to formulate a rough idea for how we’re going to build our forecast…but each section of the Profit & Loss and Balance Sheet may require a different approach.While they all differ, almost all forecasts I build include one / all of these 9 methods:1️⃣ 6 mo. historical average 🤔 How it works → take the last 6 months value. Can take it one step further by adding a buffer (like a 5% increase)💡 Why it’s useful → The future often times blends well with the past, especially in the first few months of projections2️⃣ Prior mo. balance🤔 How it works → Set your projection to last months value💡 Why it’s useful → extra helpful when forecasting the balance sheet for accounts with minimal movements3️⃣ % of revenue🤔 How it works → Set your projection to take a % of revenue💡 Why it’s useful → As revenue scales, expenses tend to scale as well4️⃣ $ per hire🤔 How it works → Set a $ figure for each hireWhy it’s useful → Expenses / capex often times scale with each new hire5️⃣ Fixed Assumption🤔 How it works → enter in any values or schedules you have on hand💡 Why it’s useful → for items like insurance or rent where you have a fixed schedule, you can plug them right into your forecast6️⃣ YoY Growth🤔 How it works → take the value from 12 months prior and add a growth factor💡 Why it’s useful → for companies with seasonality, you can match the schedule from the prior year, and add a buffer if need be7️⃣ Annual inputs🤔 How it works → Enter in assumptions for the entire year, then divide by 12 for monthly projections💡 Why it’s useful → simple and quick way to forecast for an entire year8️⃣ Departmental Intake🤔 How it works → sit down with each department head, and come up with a bottoms up budget for their department💡 Why it’s useful → collect valuable information that you may not have insight into, hold each department head accountable to results & performance9️⃣ Zeroed out🤔 How it works → forecast 0 going forward💡 Why it’s useful → can be useful if you don’t expect any future values in this account, or if you project values in another account that relates to this account===So which is the right method?There is no right one method for a business…each line item on your general ledger should be analyzed as you choose the best forecasting method.As a general idea, I typically start out with making all opex accounts other than headcount a 6 month average…and every balance sheet account other than cash + retained earnings equal to last month.From there, I can add more and more detail as necessary.What is your favorite method of forecasting?Let us know by joining in on the discussion in the comments below 👇

961

41 Comments

Look ma, I’m on Youtube!Learn The Accounting Equation like never before…I’m thrilled to announce the launch of our channel on Youtube today 🥳Over the next several months, I will be uploading videos on Accounting, FP&A, and excel topics to help you continue to grow in your career 🚀Like my content & infographics on linkedin? then you’ll LOVE the videos we’ll be producing on youtube…starting with this one on the accounting equationThe Accounting equation is often times the first thing you’ll learn in a college Accounting course…and many would say it’s the most important concept in Accounting (hence the name)But what’s so special about it? Let’s dive in.➡️ What the idea?This equation summarizes how a business can be interpreted using a report called a “Balance Sheet”.It introduces the concept of “double entry” accounting, where every transaction in a business affects 2 items in a balance sheet, and atleast 1 of these section.➡️ What exactly does it mean?Let’s do a quick set of definitions…Assets → Items of economic value that the business owns or substantially controls (cash, receivables, inventory)Liabilities → amounts that you owe to creditors (credit cards, loans, deferred revenue)Owners Equity → amounts that the owners are owed (IE: what’s left after you subtract liabilities from assets)So the accounting equation explains that all of your assets came from either amounts funded by creditors (liabilities) or owners (owners equity)➡️ What’s so special about that?Well…a lot.1️⃣ It all balancesNet Income is calculated on your P&L by taking all income accounts less all expense accounts.And that feeds into your owners equity via an account called retained earnings.So when net income goes up, your owners equity goes up…when net income goes down…your owners equity goes down.Since Assets must always = liabilities + owners equity, you know that the must be a corresponding effect in your assets or liabilities.2️⃣ Debits & CreditsDebits & Credits are the mechanism you use to showcase the movements of account balances in your general ledger.So however they work for Assets, is the complete opposite for how they work for Liabilities and Owners Equity.For example:Assets: ⬆️ Go up with a Debit, ⬇️ Go down with a creditLiabilities + Owners Equity: ⬆️ Go up with a credit, ⬇️Go down with a debitNow you know your debits & credits===I hope you enjoy our first video, because we have plenty more coming!Please don’t be shy and let me know your feedback in the comments below 👇https://lnkd.in/eAgn-4bq

281

39 Comments

Master the Financial Statements with these 123 examples of accounts (with definitions) 👇 If you understand Financial Statements…You understand so much about1️⃣ Business2️⃣ Finance3️⃣ Accountingand much more…Let’s go over 123 examples of accounts you may find on your financial statements…starting with the Profit & Loss➡️ What is the Profit & Loss (P&L)?The P&L tells you what you are EARNING…and what you are CONSUMING…Learn more about the P&L over herehttps://lnkd.in/eDspfRQXIt’s separated by:▪️ REVENUE → what you are earning via salesRead more about revenue over here https://lnkd.in/ejNEsaxqand here https://lnkd.in/euGAPzvW▪️ COGS → the cost to carry out your revenueRead more about COGS over here https://lnkd.in/eYw8EVeT▪️ OPEX → the cost to operate your businessRead more about Opex over here https://lnkd.in/eyECjBfP▪️ OTHER INCOME / OTHER EXPENSE → Other income & expense amounts that don’t relate to your core businessLearn more about Other Income / Expense over here https://lnkd.in/e5Vcb5C9➡️What is the Balance Sheet?The Balance Sheet is a snap shot in time of your businessesLearn more about the balance sheet over here: https://lnkd.in/eFDAMQnQThe Balance Sheet is broken out by…▪️ ASSETS Items of economic value that the business owns / substantially controls)Learn more about Assets over here https://lnkd.in/eCcp68Zy▪️ LIABILITIES- what the business owes to creditorsLearn more about Liabilities over here https://lnkd.in/ecwi6cE9▪️ OWNERS EQUITY (what the business owes to owners)Learn more about Owners Equity over here https://lnkd.in/eGrWvUYU===Understanding financial statements has given me a large ROI in my career...and the more you are able to understand these statementsthe better off you are to understanding your businessWhat would you add?Let me know in the comments below 👇

228

18 Comments

The ABCs of AccountingWon’t you sing along with me?A AssetsItems of Economic Value that you own / substantially controlBBalance sheetSnapshot of the business showing the Assets, Liabilities, and Owners EquityC Cash flowThe total cash entering & leaving your bank accountDDepreciationThe wear and tear on the fixed assets in our businessEEBITDAEarnings Before Interest Taxes Depreciation & AmortizationF Financial statementsThe Income Statement, Balance Sheet, and Cash FlowsGGAAPGenerally Accepted Accounting Principles HHistorical costThe cost to acquire an assetI Income statementShow’s you the income & expenses of your business, and various levels of profitabilityJJournal entriesYour Debits & CreditsKKPIs Key Performance IndicatorsLLiabilitiesObligations & amounts owed to creditors of the businessMMatching principleAn accounting principle that requires you to match the timing of income with the timing of expensesNNet incomeRevenue - COGS - Operating Expenses + Other Income - Other ExpensesOOwners EquityAmounts contributed by owners + prior earningsPProfitWhat you earn after costsQQuick ratio (Current Assets - Inventory) / Current LiabilitiesRRevenueYour incomeSShareholdersThe owners of the companyTTaxesAmounts owed to the governmentUUnearned revenueThe amount of revenue collected / due, but not yet earnedVValuationHow much a company is worthWWorking capitalCurrent Assets - Current LiabilitiesX eXpensesThe costs associated with your businessYYieldThe return on an investmentZZero-based budgetingA method of budgeting where you start from 0 and justify every financial activity===Thanks for signing along!Any other examples you’d add? Let us know in the comments below 👇PS: Download ⬇️ this poster in high resolution by visiting my website!

1,688

43 Comments

Learn about Accounts Payable 👇 ➡️ What it meansMoney a company owes to its suppliers and vendors for goods and services purchased on credit➡️ Where it shows upOn the Liabilities section of the Balance Sheet➡️ Why it’s important1️⃣ Cash Flow Management - a higher AP balance can mean that you are utilizing favorable cash flow measures for the near future, however it’s important to keep track as the amount can catch up with you2️⃣ Relationship with Suppliers - It’s important to keep track of your AP balance or your relationship with suppliers may worsen, leading to future issues with purchasing goods & services on credit, or legal action➡️ Common AP formulas1️⃣ Accounts Payable Turnover Ratio: Measures how many times a company pays off its accounts payable balance during a specific period.Formula: Purchases on Credit / Average Accounts PayableAlternate Formula: COGS / Average Accounts Payable Balance💡A high Accounts Payable Turnover Ratio means that the company is paying off it’s outstanding AP more quickly2️⃣ Days Payable Outstanding (DPO): Represents the average number of days it takes a company to pay its suppliers.Formula: Accounts Payable / Purchases on credit * Number of days.Alternate formula: Average AP / COGS * Number of Days💡A Lower DPO means the company is paying off it’s AP balance more quickly3️⃣ Average Age of Accounts Payable: Measures how long a company takes to pay off its debtsFormula: Accounts Payable / Annual Credit Purchases / 365Alternate Formula: Accounts Payable / Average Daily Cost of Goods Sold💡A lower Average Age of Accounts Payable means the company pays it’s AP balance more quickly➡️ Common Journal Entries1️⃣ When purchasing good or services on credit…Debit Software expense (or the relevant account)Credit Accounts Payable2️⃣ When paying off AP balanceDebit Accounts PayableCredit Cash===Those are my notes on Accounts PayableThere’s much more to it!What would you add?Let us know in the comments below 👇

2,557

65 Comments

Vlookup vs Hlookup vs XlookupLearn the most popular excel functions, and which one to use when 👇Lookup functions are REALLY popular in excel…because they allow you to “lookup” a value from a dataset, based off of criteria that you enter.Most people only focus on Vlookup, without realizing that there is a far more powerful lookup function available called Xlookup.Let’s explore these 3 lookup functions and become a pro:👀 Stick around till the end to grab my excel worksheet to master these 3 functions + the high res infographic 👇1️⃣ VLOOKUP💡 How it works → Searches VERTICALLY in the first column of a specified range and returns a value in the same row from a column you specify.🧮 Syntax → =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])✅ Pros →Easy to use for vertical lookups, Supported in all versions of Excel.❌ Cons → Limited to vertical searches, Searches must start in the first column of the range.🤔My take → VLOOKUP is probably the most common lookup function, but it’s sooo limited. Learn to ditch this function and focus on XLOOKUP!2️⃣ HLOOKUP💡 How it works → Searches HORIZONTALLY in the first row of a specified range and returns a value in the same column from a row you specify.🧮 Syntax → =HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])✅ Pros → Useful for horizontal lookups, Supported in all versions of Excel.❌ Cons → Limited to horizontal searches, Inefficient with large datasets.🤔My take → HLOOKUP isn’t as popular as VLOOKUP, but is very similar. As mentioned above…while this may get the job done, there is bigger and better available with XLOOKUP.3️⃣ XLOOKUP💡 How it works → Searches for a value in an array or range in EITHER DIRECTION and returns a value from a corresponding array or range.🧮 Syntax → =XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found]✅ Pros → Can search in any direction, Allows for return of an array and provides an option for a default value if no match is found, is very efficient.❌ Cons → Only available in Excel for Office 365, Excel 2019, and later versions, can be complex🤔My take → XLOOKUP solves all the issues that VLOOKUP and HLOOKUP has, and little by little will be taking over the excel lookup universe.What makes this even more powerful is when you nest another XLOOKUP inside your XLOOKUP to allow you to find the value with both your X and Y axis.===That’s my take on these 3 common lookup functions - which one is your favorite?Let us know in the comments below 👇PS: Grab the excel worksheet + high res infographic right here:🔗 https://lnkd.in/eFre5cn3

1,312

55 Comments