Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

hi I have my business financial record and i need financial analysis Everything is given you do it in professional ways on excel. you Check

hi I have my business financial record and i need financial analysis Everything is given you do it in professional ways on excel. you Check it find my mistake or any thing need changing please change it I need professional and correct work. It is not study related it is business related. cash flow, income statement, balance sheet, break even point, financial overview everything you do it in professional way work and if any error you correct it I need it fast ASAP. I know chegg not allowed that work because it is too much work but i need please please otherwise i will loss my job please i hope you understand me.

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

Fairpitch Startup Expense Capital Expenditure Rent Advertisement (ads and blog posts) Website completion and maintenance Top spreaders commissions Employees Salaries Miscellaneous Cost S 84.000 $360,000 $ 120.000 $ 720,000 $ 120.000 $ 100,000 $ 1,504,000 S $ 400,000 S 300,000 S 700,000 Total Startup Expenses Owner's Investment Investors Loan Total Investment 983 Fairpitch financial edit-15.docx - Microsoft Word Mailings Review View References Home Insert Page Layout . . ABCDE Subtle Em... 15. 2 F-F >= 24T Subtitle 11 Title Heading 2 Calibri Normal Heading 1 11 No Spaci. aby - A Styles * Cut 3 Copy Paste Format Painter Clipboard B Usbe xxx Paragraph Font Year 4 Year 5 General Assumptions Year 3 Year 1 Year 2 8.0% 8.0% 8.0% 8.0% 8.0% $ $ 400.000 700,000 $ 50% 30% 10% Tax Owner's Investment Investors Total Investment Assumed Depreciation in Assets Annual Growth in Revenue Annual Growth in Cost Annual Growth in Rent & Salary Repayment Plan 20% 30% 15% 30% 40% 30% 15% 30% 15% N/A N/A 15% 3% 3% 3% 3% 3% 5% N/A N/A 5% Page 2 of 9 Words: 983 O RI Type here to search -65 Home Insert Page Layout Fairpitch financial edit-15.docx - Microsoft Word References Mailings Review View Calibri 11 A A AB Cut = Copy Format Painter Clipboard - E 21 B / . , U abe x, XA ab A Normal 1 No Spaci... Font Heading 1 Heading 2 Title Subtitle Sut Paragraph Styles Profit and Loss Year 1 $ Year 2 Year 3 $ $ Year 4 $ Year 5 $ Sales Total Sales 2,400,000 3,120.000 4,056,000 5.272.800 6.854.640 Total Cost of Sales 0 0 0 0 0 Gross Margin Gross Margin % 2.400.000 100.00% 3,120,000 100.00% 4.056,000 100.00% 5.272.800 100.00% 6.854.640 100.00% Operating Expenses Rent 84.000 86,520.00 89.116 91,789.07 94,543 360,000 414,000 476,100.00 547,515 Advertising Website completion and maintenance 629,642.25 120,000 138.000 158.700.00 182.505 209.880.75 Words: 983 Type here to search BI board Font 1 Normal No Space Heading 1 Heading 2 Title . Subtitle 4GBbc Subtle Er Paragraph Rent Styles 84,000 86,520.00 89,116 91,789.07 94,543 Advertising Website completion and maintenance 360,000 414,000 476,100.00 547,515 629.642.25 120,000 138.000 158,700.00 182,505 209,880.75 Top Spreader Commission 720,000 828,000.00 952.200 1,095,030.00 1,259,285 Employees' Salaries 120,000 123,600 127,308.00 131.127 135,061.06 Miscellaneous Total Operating Expenses 100.000 1,504,000 105,000.00 1,695.120 110.250 1,913,674 115,762.50 2,163,729 121.551 2.449.962 Operating Income Operating Margin 896,000 37.33% 1,424.880 45.67% 2.142.326 52.82% 3,109,071 58.96% 4,404,678 64.26% EBITDA 896.000 1.424.880 2.142.326 3,109,071 4,404,678 ds: 983 Depreciation & Amortization 0 0 0 0 0 71.244.00 107.116.32 93.272.14 Repayment Plan Interest Expense Tax Incurred 71680 113990 171386 248726 352374 $ Net Profit Net Profit/Sales % 824.320 $ 1.239.646 39.73% $ 1,863.824 45.95% $ 2.767,073 52.48% 34.35% $ 4.052.304 59.12% OPERATING EXPENSES (For the first Year) Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month Month 8 Month 9 Month 10 Month 11 Month 12 Total $ S $ $ $ $ $ $ $ $ $ $ Rent 7,000 7,000 7,000 7,000 7,000 7.000 7,000 7,000 7,000 7,000 7000 7,000 Advertising 30.000 84,000 30.000 30.000 30,000 30,000 30,000 30,000 30.000 30,000 30,000 30,000 30,000 360,000 HO Page: 4 of 9 Words: 983 Type here to search 13696 - ji TO 30 dal 10:54 AM $ Net Profit Net Profit/Sales % $ 2,767,073 824,320 34.35% $ 1,239,646 39.73% $ 1,863,824 45.95% $ 4,052,304 59.12% 52.48% OPERATING EXPENSES (For the first Year) Month 1 Month 2 Month 3 Month Month 4 Month 5 Month Month 8 Month 9 Month 10 Month 11 6 Month 12 Total $ $ $ $ $ $ $ $ $ $ $ $ Rent 7,000 7,000 7,000 7,000 7,000 7,000 7,000 7,000 7,000 7,000 7000 7,000 84,000 Advertising 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 360,000 10,000 10,000 10,000 10,000 Emplovees Salaries Top Spreaders Commission 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 120,000 60,000 60,000 60,000 60,000 60,000 60,000 60,000 60,000 60,000 60,000 60,000 60,000 720,000 Website Completion 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 120,000 Other admin expenses Miscellaneous 8,333 8,335 8.333 8,333 8,353 8,333 8,333 8.333 8,333 8,333 8,333 8,333 Total 100,000 125,333 125,333 125,333 125,333 125,333 125,333 125,333 125,333 125,333 125,333 125,333 125,333 1,504,000 f9 Words: 983 Type here to search 136% C Calibri Title Subtitle Heading 1 Heading 2 Emphasi Subtle Em... 1 Normal I No Spaci... ab LU a copy Paste Format Painter Clipboard B U Styles Font Paragraph Cash Flow Year 1 Year 3 Year 4 Year 2 $ Year 5 $ $ $ $ Cash From Operations Cash Sales 2,400,000 3,120,000 4,056,000 5,272,800 6,854,640 Subtotal Cash From Operations 2,400,000 3,120,000 4,056,000 5,272,800 6,854,640 Additional Cash Received Owner's Investment 0 0 0 O 400,000 0 0 0 Investors New Long-term Liabilities Sales of Other Current Assets Sales of Long-term Assets New Investment Received Subtotal Cash Received 0 0 0 0 0 2.800.000 3,120.000 4,056.000 5,272,800 6,854.640 Page: 5 of 9 Words: 983 Type here to search O B E E 30C 0 0 0 0 0 Sales of Long-term Assets New Investment Received Subtotal Cash Received 0 0 0 0 0 3,120,000 2,800,000 4,056,000 5,272,800 6,854,640 Expenditures Year 1 Year 2 Year 3 Year 4 Year 5 Expenditures from Operations Total Cost of Sales (Ambassador of Change Program) 0 0 0 0 0 1,504,000 1,695,120 1,913,674 2,163,729 Total Operating Expenses Interest Expense Tax Incurred 2,449,962 71680 113990 171386 248726 352374 Subtotal Spent on Operations 1,575,680 1.809,110 2.085,060 2,412,455 2,802,336 Additional Cash Spent Page 5 of 9 Words: 983 Type here to search o Font Clipboard 0 0 0 0 0 Other Liabilities Principal Repayment Long-term Liabilities Principal Repayment 0 0 0 1,504,000 0 ooo 0 0 0 Startup Expenses Purchase Long-term Assets Owner's Drawing Subtotal Cash Spent 0 0 0 0 1.809.110 2,085,060 2,802,336 2,412,455 3,079,680 $ 1,310,890 $ 2,860,345 Net Cash Flow $ (279,680) $ (279.680) $ 1,970,940 $ 3,002.150 $ 4,052,304 $ 9.914,799 $ 1.031.210 $ 5,862,495 Cash Balance Clipboard Font Paragraph Balance Sheet Year 1 Year 2 Year 3 Year 4 Year 5 Starting Bal. $ $ $ $ $ $ Assets Current Assets Cash 3,002,150 9,914,799 (804,000) 0 (804,000) Other Current Assets (279,680) 0 (279,680) 1,031,210 0 0 5,862,495 0 5,862,495 0 Total Current Assets 1,031,210 3,002,150 9,914,799 1,420,000 1,420,000 1,420,000 1,420,000 1,420,000 1,420,000 Long-term Assets Long-term Assets Accumulated Depreciation Total Long-term Assets 0 142,000 284,000 426,000 568,000 710,000 Total Assets 1,420,000 616.000 1,278,000 998,320 1,136.000 2.167.210 994,000 3,996,150 852,000 6,714,495 710,000 10.624,799 Page 7 of 9 Words: 983 Tuna horo to Total Long-term Assets 1,420,000 616,000 1,278,000 998,320 1,136,000 2,167,210 994,000 3,996,150 852,000 6,714,495 710,000 10,624,799 Total Assets Liabilities and Capital 0 0 0 0 0 Current Liabilities Accounts Payable Current Borrowing Other Current Liabilities 0 0 0 0 0 0 0 0 0 0 0 0. Subtotal Current Liabilities 0 0 0 0 0 Long-term Liabilities Page: 7 of 9 Words: 983 Type here to search o B6 30C Font Paragraph Clipboard Total Liabilities 0 0 0 0 0 0 0 Paid-in Capital Retained Earnings Earning Total Capital Total Liabilities and Capital 824,320 824,320 998,320 2,063,966 1,239,646 2,167,210 3,927,790 1,863,824 3,996,150 6,694,863 2,767,073 6,714,495 10,747,167 4,052,304 10,624,799 616,000 616,000 998,320 2,167,210 3,996.150 6,714,495 10.624,799 Net Worth $ 616,000 $ 998,320 $ 2.167.210 $ 3,996,150 $ 6,714,495 $ 10,624,799 ge: 8 of 9 Words: 983 To Styles Paste Format Painter Cipboard Paragraph Font Breakeven Analysis Year 1 Year 2 Year 3 Year 4 Year 5 Fixed cost Variable Cost % Gross Margin% Break Even Income Revenue 1,504,000 0.00% 100.00% 1,504,000 2,400,000 1,695,120 0.00% 100.00% 1,695,120 3,120,000 1,913,674 0.00% 100.00% 1,913,674 4,056,000 2,163,729 0.00% 100.00% 2,163,729 5,272,800 2,449,962 0.00% 100.00% 2,449.962 6,854,640 Financial Overview Total Revenue Total Expenses Net Profit Year 1 $ 2,400,000 $ 1,504,000 $ 824,320 Year 2 $ 3,120,000 $ 1,695.120 $ 1.239.646 Year 3 $ 4,056,000 $ 1,913.674 $ 1,863,824 Year 4 $ 5.272.800 $ 2.163,729 $ 2,767,073 Year 5 $ 6,854,640 $ 2.449.962 $ 4,052,304 Page 9 of 9 Words: 983 Type here to search 0 ) HE 30C Fairpitch Startup Expense Capital Expenditure Rent Advertisement (ads and blog posts) Website completion and maintenance Top spreaders commissions Employees Salaries Miscellaneous Cost S 84.000 $360,000 $ 120.000 $ 720,000 $ 120.000 $ 100,000 $ 1,504,000 S $ 400,000 S 300,000 S 700,000 Total Startup Expenses Owner's Investment Investors Loan Total Investment 983 Fairpitch financial edit-15.docx - Microsoft Word Mailings Review View References Home Insert Page Layout . . ABCDE Subtle Em... 15. 2 F-F >= 24T Subtitle 11 Title Heading 2 Calibri Normal Heading 1 11 No Spaci. aby - A Styles * Cut 3 Copy Paste Format Painter Clipboard B Usbe xxx Paragraph Font Year 4 Year 5 General Assumptions Year 3 Year 1 Year 2 8.0% 8.0% 8.0% 8.0% 8.0% $ $ 400.000 700,000 $ 50% 30% 10% Tax Owner's Investment Investors Total Investment Assumed Depreciation in Assets Annual Growth in Revenue Annual Growth in Cost Annual Growth in Rent & Salary Repayment Plan 20% 30% 15% 30% 40% 30% 15% 30% 15% N/A N/A 15% 3% 3% 3% 3% 3% 5% N/A N/A 5% Page 2 of 9 Words: 983 O RI Type here to search -65 Home Insert Page Layout Fairpitch financial edit-15.docx - Microsoft Word References Mailings Review View Calibri 11 A A AB Cut = Copy Format Painter Clipboard - E 21 B / . , U abe x, XA ab A Normal 1 No Spaci... Font Heading 1 Heading 2 Title Subtitle Sut Paragraph Styles Profit and Loss Year 1 $ Year 2 Year 3 $ $ Year 4 $ Year 5 $ Sales Total Sales 2,400,000 3,120.000 4,056,000 5.272.800 6.854.640 Total Cost of Sales 0 0 0 0 0 Gross Margin Gross Margin % 2.400.000 100.00% 3,120,000 100.00% 4.056,000 100.00% 5.272.800 100.00% 6.854.640 100.00% Operating Expenses Rent 84.000 86,520.00 89.116 91,789.07 94,543 360,000 414,000 476,100.00 547,515 Advertising Website completion and maintenance 629,642.25 120,000 138.000 158.700.00 182.505 209.880.75 Words: 983 Type here to search BI board Font 1 Normal No Space Heading 1 Heading 2 Title . Subtitle 4GBbc Subtle Er Paragraph Rent Styles 84,000 86,520.00 89,116 91,789.07 94,543 Advertising Website completion and maintenance 360,000 414,000 476,100.00 547,515 629.642.25 120,000 138.000 158,700.00 182,505 209,880.75 Top Spreader Commission 720,000 828,000.00 952.200 1,095,030.00 1,259,285 Employees' Salaries 120,000 123,600 127,308.00 131.127 135,061.06 Miscellaneous Total Operating Expenses 100.000 1,504,000 105,000.00 1,695.120 110.250 1,913,674 115,762.50 2,163,729 121.551 2.449.962 Operating Income Operating Margin 896,000 37.33% 1,424.880 45.67% 2.142.326 52.82% 3,109,071 58.96% 4,404,678 64.26% EBITDA 896.000 1.424.880 2.142.326 3,109,071 4,404,678 ds: 983 Depreciation & Amortization 0 0 0 0 0 71.244.00 107.116.32 93.272.14 Repayment Plan Interest Expense Tax Incurred 71680 113990 171386 248726 352374 $ Net Profit Net Profit/Sales % 824.320 $ 1.239.646 39.73% $ 1,863.824 45.95% $ 2.767,073 52.48% 34.35% $ 4.052.304 59.12% OPERATING EXPENSES (For the first Year) Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month Month 8 Month 9 Month 10 Month 11 Month 12 Total $ S $ $ $ $ $ $ $ $ $ $ Rent 7,000 7,000 7,000 7,000 7,000 7.000 7,000 7,000 7,000 7,000 7000 7,000 Advertising 30.000 84,000 30.000 30.000 30,000 30,000 30,000 30,000 30.000 30,000 30,000 30,000 30,000 360,000 HO Page: 4 of 9 Words: 983 Type here to search 13696 - ji TO 30 dal 10:54 AM $ Net Profit Net Profit/Sales % $ 2,767,073 824,320 34.35% $ 1,239,646 39.73% $ 1,863,824 45.95% $ 4,052,304 59.12% 52.48% OPERATING EXPENSES (For the first Year) Month 1 Month 2 Month 3 Month Month 4 Month 5 Month Month 8 Month 9 Month 10 Month 11 6 Month 12 Total $ $ $ $ $ $ $ $ $ $ $ $ Rent 7,000 7,000 7,000 7,000 7,000 7,000 7,000 7,000 7,000 7,000 7000 7,000 84,000 Advertising 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 360,000 10,000 10,000 10,000 10,000 Emplovees Salaries Top Spreaders Commission 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 120,000 60,000 60,000 60,000 60,000 60,000 60,000 60,000 60,000 60,000 60,000 60,000 60,000 720,000 Website Completion 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 120,000 Other admin expenses Miscellaneous 8,333 8,335 8.333 8,333 8,353 8,333 8,333 8.333 8,333 8,333 8,333 8,333 Total 100,000 125,333 125,333 125,333 125,333 125,333 125,333 125,333 125,333 125,333 125,333 125,333 125,333 1,504,000 f9 Words: 983 Type here to search 136% C Calibri Title Subtitle Heading 1 Heading 2 Emphasi Subtle Em... 1 Normal I No Spaci... ab LU a copy Paste Format Painter Clipboard B U Styles Font Paragraph Cash Flow Year 1 Year 3 Year 4 Year 2 $ Year 5 $ $ $ $ Cash From Operations Cash Sales 2,400,000 3,120,000 4,056,000 5,272,800 6,854,640 Subtotal Cash From Operations 2,400,000 3,120,000 4,056,000 5,272,800 6,854,640 Additional Cash Received Owner's Investment 0 0 0 O 400,000 0 0 0 Investors New Long-term Liabilities Sales of Other Current Assets Sales of Long-term Assets New Investment Received Subtotal Cash Received 0 0 0 0 0 2.800.000 3,120.000 4,056.000 5,272,800 6,854.640 Page: 5 of 9 Words: 983 Type here to search O B E E 30C 0 0 0 0 0 Sales of Long-term Assets New Investment Received Subtotal Cash Received 0 0 0 0 0 3,120,000 2,800,000 4,056,000 5,272,800 6,854,640 Expenditures Year 1 Year 2 Year 3 Year 4 Year 5 Expenditures from Operations Total Cost of Sales (Ambassador of Change Program) 0 0 0 0 0 1,504,000 1,695,120 1,913,674 2,163,729 Total Operating Expenses Interest Expense Tax Incurred 2,449,962 71680 113990 171386 248726 352374 Subtotal Spent on Operations 1,575,680 1.809,110 2.085,060 2,412,455 2,802,336 Additional Cash Spent Page 5 of 9 Words: 983 Type here to search o Font Clipboard 0 0 0 0 0 Other Liabilities Principal Repayment Long-term Liabilities Principal Repayment 0 0 0 1,504,000 0 ooo 0 0 0 Startup Expenses Purchase Long-term Assets Owner's Drawing Subtotal Cash Spent 0 0 0 0 1.809.110 2,085,060 2,802,336 2,412,455 3,079,680 $ 1,310,890 $ 2,860,345 Net Cash Flow $ (279,680) $ (279.680) $ 1,970,940 $ 3,002.150 $ 4,052,304 $ 9.914,799 $ 1.031.210 $ 5,862,495 Cash Balance Clipboard Font Paragraph Balance Sheet Year 1 Year 2 Year 3 Year 4 Year 5 Starting Bal. $ $ $ $ $ $ Assets Current Assets Cash 3,002,150 9,914,799 (804,000) 0 (804,000) Other Current Assets (279,680) 0 (279,680) 1,031,210 0 0 5,862,495 0 5,862,495 0 Total Current Assets 1,031,210 3,002,150 9,914,799 1,420,000 1,420,000 1,420,000 1,420,000 1,420,000 1,420,000 Long-term Assets Long-term Assets Accumulated Depreciation Total Long-term Assets 0 142,000 284,000 426,000 568,000 710,000 Total Assets 1,420,000 616.000 1,278,000 998,320 1,136.000 2.167.210 994,000 3,996,150 852,000 6,714,495 710,000 10.624,799 Page 7 of 9 Words: 983 Tuna horo to Total Long-term Assets 1,420,000 616,000 1,278,000 998,320 1,136,000 2,167,210 994,000 3,996,150 852,000 6,714,495 710,000 10,624,799 Total Assets Liabilities and Capital 0 0 0 0 0 Current Liabilities Accounts Payable Current Borrowing Other Current Liabilities 0 0 0 0 0 0 0 0 0 0 0 0. Subtotal Current Liabilities 0 0 0 0 0 Long-term Liabilities Page: 7 of 9 Words: 983 Type here to search o B6 30C Font Paragraph Clipboard Total Liabilities 0 0 0 0 0 0 0 Paid-in Capital Retained Earnings Earning Total Capital Total Liabilities and Capital 824,320 824,320 998,320 2,063,966 1,239,646 2,167,210 3,927,790 1,863,824 3,996,150 6,694,863 2,767,073 6,714,495 10,747,167 4,052,304 10,624,799 616,000 616,000 998,320 2,167,210 3,996.150 6,714,495 10.624,799 Net Worth $ 616,000 $ 998,320 $ 2.167.210 $ 3,996,150 $ 6,714,495 $ 10,624,799 ge: 8 of 9 Words: 983 To Styles Paste Format Painter Cipboard Paragraph Font Breakeven Analysis Year 1 Year 2 Year 3 Year 4 Year 5 Fixed cost Variable Cost % Gross Margin% Break Even Income Revenue 1,504,000 0.00% 100.00% 1,504,000 2,400,000 1,695,120 0.00% 100.00% 1,695,120 3,120,000 1,913,674 0.00% 100.00% 1,913,674 4,056,000 2,163,729 0.00% 100.00% 2,163,729 5,272,800 2,449,962 0.00% 100.00% 2,449.962 6,854,640 Financial Overview Total Revenue Total Expenses Net Profit Year 1 $ 2,400,000 $ 1,504,000 $ 824,320 Year 2 $ 3,120,000 $ 1,695.120 $ 1.239.646 Year 3 $ 4,056,000 $ 1,913.674 $ 1,863,824 Year 4 $ 5.272.800 $ 2.163,729 $ 2,767,073 Year 5 $ 6,854,640 $ 2.449.962 $ 4,052,304 Page 9 of 9 Words: 983 Type here to search 0 ) HE 30C

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Corporate Finance, European Edition

Authors: Peter Moles, Robert Parrino, David S. Kidwell

1st Edition

0470683708, 9780470683705

More Books

Students also viewed these Accounting questions

Question

What two languages include multiple assignments?

Answered: 1 week ago

Question

Do you agree that unions stifle creativity? Why or why not?

Answered: 1 week ago

Question

6 What is the selection phase?

Answered: 1 week ago