1. How many products are being sold by this business? What are the products?

2. What is the unit cost for product 3? How many were sold in June 2020?

3. What is the cost of packaging for product 1?

4. How much did it cost to sell product 1 in April 2020

5. If Gross profit in January was $4,135, why would this business owner only show $2,951 in Net Income?

6. Based upon the Cash Flow Forecast, does this business accept credit (Promise to pay later)?

7. What are the margins between revenue and COGS?

[Combany Namel 3-Year Cash Flow [Comoanv Name] 12-Month Cash Flow \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|c|} \hline \begin{tabular}{l} Period Beginning \\ Period Ending \end{tabular} & \begin{aligned} \( 1 / 1 / 14 \\ 1 / 31 / 14\end{aligned} \) & \begin{tabular}{r} 211/4 \\ 22814 \end{tabular} & \begin{tabular}{r} 3/114 \\ 331/4 \end{tabular} & \begin{tabular}{r} 41/74 \\ 43074 \end{tabular} & \begin{tabular}{r} 61/74 \\ 631/14 \end{tabular} & \begin{tabular}{r} 61/14 \\ 63014 \end{tabular} & \begin{tabular}{r} 7/1/14 \\ 7/31/74 \end{tabular} & \begin{tabular}{r} 81/14 \\ 831/14 \end{tabular} & \begin{tabular}{r} 91/14 \\ 93014 \end{tabular} & \begin{tabular}{r} 101//14 \\ 10/31/14 \end{tabular} & \begin{tabular}{r} 11/1/14 \\ 11/90/14 \end{tabular} & \begin{tabular}{r} 12/1/14 \\ 12/31/14 \end{tabular} \\ \hline \begin{tabular}{c} Cash at Beginning of Period \\ Cash at End of Period \end{tabular} & \begin{tabular}{l} 16.700 \\ 17.326 \end{tabular} & \begin{tabular}{l} 17,326 \\ 17,326 \end{tabular} & \begin{tabular}{l} 17,326 \\ 17,326 \end{tabular} & \begin{tabular}{l} 17,326 \\ 17,326 \end{tabular} & \begin{tabular}{l} 17,326 \\ 17,326 \end{tabular} & \begin{tabular}{l} 17,325 \\ 17,925 \end{tabular} & \begin{tabular}{l} 17,325 \\ 17,325 \end{tabular} & \begin{tabular}{l} 17,325 \\ 17,325 \end{tabular} & \begin{tabular}{l} 17,925 \\ 17,925 \end{tabular} & \begin{tabular}{l} 17,925 \\ 17,925 \end{tabular} & \begin{tabular}{l} 17,325 \\ 17,326 \end{tabular} & \begin{tabular}{l} 17.326 \\ 17.326 \end{tabular} \\ \hline \end{tabular} Cash receipts from Customers Other operasions Cash paid for Imventorf purchases General eperating and admin exerses Wage expenses Interest Income taxes Net Cash Flow from Operations \begin{tabular}{|l|l|l|l|l|l|l|l|l|l|} \hline 67.767 & & & & & & & & \\ \hline & & & & & & & & & \\ \hline \end{tabular} Cash receiots from Sole of propertf and equigment Cellection of prineipal on loans Sole of investrent securities Cash paid for Purchase of propertf and equipment Making loans to othe entities Purchase of imvesiment secinties Net Cash Flow from Investing Activiti \begin{tabular}{|l|l|l|l|l|l|l|l|l|l|l|} \hline(6.260) & & & & & & & & & & \\ \hline & & & & & & & & & & \\ \hline & & & & & & & & & \\ \hline \end{tabular} \begin{tabular}{|l|l|l|l|l|l|l|l|l|l|} \hline 2.500 & & & & & & & & \\ \hline & & & & & & & & & \\ \hline \end{tabular} Iszuance of stock Borrowing Cash paid for Repurctase of stock (reasurf stock) Repstment of loars Dividends Net Cash Flow from Financing Activi Net Cash Flow \begin{tabular}{|l|l|l|l|l|l|l|l|l|l|} \hline \\ \hline & & & & & & & & & \\ \hline \end{tabular} Templates by Vertex42 com e2012 Veras:42 LLe Company Name Here: Sources \& Uses Sources (where do you get the money to start the business): Uses (how will you use the money): Company Name Here: Assumption Sheet Amounts to Enter into Forecasting Spreadsheet: How do I get those numbers? voilpaliy ivalie neIe: Dreak cven Mnalysis: Revenue: Cost of Goods (\%) Fixed Costs: Contribution margin (\$) AKA Gross Margin Contribution margin (\%) AKA Gross Margin Revenue: Cost of Goods Sold: Gross Profit: Fixed Costs: Net Income: Fixed Costs: Rent Insurance Telephone Internet Advertising/Promotion Salaries Payroll Deductions Other costs in Income Statement/ Cost Budget Total Fixed Costs: Artist LLC Jewelry Sales Break even in Units = Fixed Costs/ (Average Unit Price - Average Unit Cost of Goods) 654 Note: Average Unite Price-Average Unit Cost of Goods= Contribution Margin Per Unit Average Unit Price = Average Cost of Goods =$29.67 Sum of all product cost of goods soldumber of products $20,280.41 61% Contribution Margin ( $ )/Revenue \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|c|c|} \hline Total & Month 1 & Month 2 & Month 3 & Month 4 & Month 5 & Month 6 & Month 7 & Month 8 & Month 9 & Month 10 & Month 11 & Month 12 & Total \\ \hline 95,347.14 & & & & & & & & & & & & & 95,347.14 \\ \hline 37,368.61 & & & & & & & & & & & & & 37,368.61 \\ \hline 57,978.53 & - & - & - & - & - & - & - & - & - & - & - & - & 57,978.53 \\ \hline 20,280.41 & - & - & - & - & - & - & - & - & - & - & - & - & 20,280.41 \\ \hline 37,698.12 & - & - & - & - & - & - & - & - & - & - & - & - & 37,698.12 \\ \hline \end{tabular} S 20,280 $ 20,280 \begin{tabular}{|c|c|c|} \hline Company Name & lere: Jewele & ery Woods \\ \hline Start Up Costs & & These numbers are an example and they might be incorrect. \\ \hline Item & Amount & Explanation \\ \hline LLC License & $90 & \\ \hline TPT License & $108 & $12 per vear per city. If vou need TPT for 3 cities that will be \\ \hline Other License/permit & & \\ \hline Domain & $20 & This is your domanin name per vear. You can register at \\ \hline Website & $114 & This is an estimate for the mothly fee for 6 months for a website \\ \hline Hosting & & You can host your website or if you use a template it will most \\ \hline SSL & $60 & This is for secure transactions if you do ecommerce. If you use a \\ \hline Insurance & $900 & This is business insurance. If you need it, multiply the monthly \\ \hline Utility Deposits & $0 & If vou rent a commercial space. vou will need about 2mo of rent \\ \hline Furniture/office equip & $0 & \\ \hline Rent deposit & - & If vou need a commercial space, vou will have to put a deposit \\ \hline Beginning Inventory & $2,000 & \\ \hline Accountant & $600 & You can use an accounting software such as quickbooks.com. \\ \hline Consultant & $0 & \\ \hline Marketing Materials & $2,000 & \\ \hline Loan Fees & $0 & If vou are taking a loan, go to the Loan Pavment tab and enter \\ \hline Other (name) & & \\ \hline & & \\ \hline & & \\ \hline Total Startup & $5,892 & \\ \hline \end{tabular} 0000001 Loan Amortization Schedule Enter the specific terms for your business loan in the blue sections bel