Excel; Valuations
What is each individual box in Excel or Google Sheets called?
A cell
What is the form you send directly to the IRS to file your taxes, that summarizes your earnings and deductions?
Form 1040
What question should you never ask in the 1st interview?
The contribution margin formula is...
Price minus cost (for a single product)
When you own stock, you really bought a ________of ownership in a company.
share
What is each Excel page called?
A spreadsheet
What is the form that your employer gives you in January that summarizes your earnings from the previous year?
W-2 form
True / False: it is best to arrive to a job interview 30 minutes early.
False. No more than 10-15 mins.
The formula for COGS is...
Cost x Units sold (for all products combined)
What does it mean to diversify your portfolio?
Spread out your stock purchases into multiple industries / types of stock to cover yourself in case there are unexpected losses. Also bonds / ETFs.
Write out the correct formula that will add together all the data in column D from row 3 through 8.
=Sum(D3: D8)
What is the form that the employer gives you upon hire that you fill out? Also, what is the purpose of this form?
W-4 form
Determines the amount of income you want withheld for your taxes.
1) Rambling. Should answer the questions directly.
2) Talking too much about yourself without coming back to how your skills can benefit the company.
3) Improper dress or attitude
ETC
Give 3 examples of fixed costs
Salaries
Rent
Utilities
Insurance
What is the purpose of an IPO?
An IPO (Initial Public Offering) allows a company to enter the primary market, trading publicly with an initial set of investors.
Write out the correct formula to find the highest value in column H, spanning from row 2 through 12.
=Max(H2: H12)
Answers vary, but might include:
Donations to charity
Deposits into a retirement account
Student loan interest
Medical expenses
Home mortgage interest
A resume should never be longer than ______ pages, and a cover letter should never be longer than ______ paragraphs.
2 pages, 4 paragraphs
The breakeven point formula for a single product is...
Fixed costs divided by contribution margin
The DOW Jones industrial average
The NASDAQ
The S&P 500
In a sales pitch, a company is asking a group of investors for $100,000 in exchange for 20% of their company. What is the valuation they are proposing for their company?
$500,000
What are two possible reasons you might have a balance due after submitting your 1040 form?
1) Capital gains from stocks / other outside income
2) An employer made a mistake and took out too little.
What should the final paragraph of a cover letter include?
A formulaic closing, including thanking them for the opportunity again, and scheduling an interview at a mutually convenient time.
The process of finding the BEP for multiple products in units, broken down into steps! Good luck, you've got this :) #worktogether
1) Find the contribution margin of each product
2) Find the sales mix: proportion of sales among the products, and total those numbers together.
3) Multiply each CM by sales mix figure, then total these.
4) Divide this total in #3 by the total sales mix figure
5) Take fixed costs (given to you) and divide by figure in #4
6) Find decimal version of sales mix proportions and multiply by figure in #5.
Explain the difference between the primary and secondary market.
Primary market: Initial investors. Can only buy and sell once. You are purchasing shares DIRECTLY from the company.
Secondary market: You are now purchasing from investors acting as middlemen. Subject to a larger scale of economic changes such as supply / demand.