Beyond-Wash & Auto Detailing Industry
Pro-forma balance sheet
Balance sheet forecast | |||
As at | December 2023 | ||
Assets | |||
Current assets | $873,080 | ||
Cash | $232,544 | ||
Petty cash | $22,000 | ||
Accounts receivable | $500,313 | ||
Stock | $49,823 | ||
Short-term investment | $0 | ||
Prepaid expenses | $56,400 | ||
Long-term investment | $12,000 | ||
Fixed assets | $1,474,502 | ||
Land | $571,698 | ||
Buildings | $39,563 | ||
Improvements | $150,530 | ||
Equipment | $422,211 | ||
Furniture | $20,500 | ||
Car wash stands | $270,000 | ||
Total assets | $2,347,582 | ||
Liabilities | |||
Current liabilities | $275,084 | ||
Accounts payable | $46,900 | ||
Interest payable | $52,329 | ||
Taxes payable | $23,000 | ||
Income tax | $27,450 | ||
Sales tax | $12,855 | ||
Payroll accrual | $112,550 | ||
Long-term liabilities | $446,520 | ||
Borrowings | $446,520 | ||
Total liabilities | $721,604 | ||
Net assets | $1,625,979 | ||
Owner’s equity | |||
Retained earnings | $455,000 | ||
Current year earnings | $1,892,582 | ||
Total equity | $2,347,582 |
Are you interested in obtaining an unpublished version of this copy or topic ? Get in touch with us. Our team of experts is ready to help.
Assumptions made for the balance sheet
The balance sheet shown above is based on various assumptions. The figures are based on market trends and thus justified despite the assumptions. For instance,
The figures provided are aggregated for 12 months for the projected year ending 2023.
Since the business will offer services as the major revenue-generating event, car detailing and accessories compose the stock.
The stock is taken as 5.71% of the sales revenue. The rest of the sales revenue is raised from service activities.
Borrowings relate to a long-term loan obtained to fund operations
Pro-forma income statement
Profit and loss forecast | |||||||||||||
Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Totals | |
Revenue | $56,000.00 | $100,800.00 | $141,120.00 | $197,568.00 | $276,595.20 | $387,233.28 | $542,126.59 | $758,977.23 | $1,062,568.12 | $1,487,595.37 | $2,082,633.52 | $2,915,686.92 | $10,008,904.23 |
Cost of goods sold | $20,000.00 | $24,000.00 | $100,800.00 | $141,120.00 | $197,568.00 | $276,595.20 | $387,233.28 | $542,126.59 | $758,977.23 | $1,062,568.12 | $1,487,595.37 | $2,082,633.52 | $7,081,217.31 |
Gross profit | $36,000.00 | $76,800.00 | $40,320.00 | $56,448.00 | $79,027.20 | $110,638.08 | $154,893.31 | $216,850.64 | $303,590.89 | $425,027.25 | $595,038.15 | $833,053.41 | $2,927,686.92 |
Expenses | |||||||||||||
Accounting fees | $400.00 | $824.00 | $848.72 | $874.18 | $900.41 | $927.42 | $955.24 | $983.90 | $1,013.42 | $1,043.82 | $1,075.13 | $1,107.39 | $10,953.62 |
Advertising | $500.00 | $1,030.00 | $1,060.90 | $1,092.73 | $1,125.51 | $1,159.27 | $1,194.05 | $1,229.87 | $1,266.77 | $1,304.77 | $1,343.92 | $1,384.23 | $13,692.03 |
Bank charges | $250.00 | $514.00 | $529.42 | $545.30 | $561.66 | $578.51 | $595.87 | $613.74 | $632.16 | $651.12 | $670.65 | $690.77 | $6,833.21 |
Bank interest | $500.00 | $1,030.00 | $1,060.90 | $1,092.73 | $1,125.51 | $1,159.27 | $1,194.05 | $1,229.87 | $1,266.77 | $1,304.77 | $1,343.92 | $1,384.23 | $13,692.03 |
Depreciation | $1,000.00 | $2,060.00 | $2,121.80 | $2,185.45 | $2,251.02 | $2,318.55 | $2,388.10 | $2,459.75 | $2,533.54 | $2,609.55 | $2,687.83 | $2,768.47 | $27,384.06 |
Electricity and gas | $3,000.00 | $6,180.00 | $6,365.40 | $6,556.36 | $6,753.05 | $6,955.64 | $7,164.31 | $7,379.24 | $7,600.62 | $7,828.64 | $8,063.50 | $8,305.40 | $82,152.18 |
Equipment hire/lease | $500.00 | $1,030.00 | $1,060.90 | $1,092.73 | $1,125.51 | $1,159.27 | $1,194.05 | $1,229.87 | $1,266.77 | $1,304.77 | $1,343.92 | $1,384.23 | $13,692.03 |
Insurance | $800.00 | $1,648.00 | $1,697.44 | $1,748.36 | $1,800.81 | $1,854.84 | $1,910.48 | $1,967.80 | $2,026.83 | $2,087.64 | $2,150.27 | $2,214.77 | $21,907.25 |
Legal fees | $50.00 | $103.00 | $106.09 | $109.27 | $112.55 | $115.93 | $119.41 | $122.99 | $126.68 | $130.48 | $134.39 | $138.42 | $1,369.20 |
Motor vehicle expenses | $600.00 | $1,236.00 | $1,273.08 | $1,311.27 | $1,350.61 | $1,391.13 | $1,432.86 | $1,475.85 | $1,520.12 | $1,565.73 | $1,612.70 | $1,661.08 | $16,430.44 |
Postage, telephone, and fax | $1,000.00 | $2,060.00 | $2,121.80 | $2,185.45 | $2,251.02 | $2,318.55 | $2,388.10 | $2,459.75 | $2,533.54 | $2,609.55 | $2,687.83 | $2,768.47 | $27,384.06 |
Stationery | $900.00 | $1,854.00 | $1,909.62 | $1,966.91 | $2,025.92 | $2,086.69 | $2,149.29 | $2,213.77 | $2,280.19 | $2,348.59 | $2,419.05 | $2,491.62 | $24,645.65 |
Rent | $12,500.00 | $25,750.00 | $26,522.50 | $27,318.18 | $28,137.72 | $28,981.85 | $29,851.31 | $30,746.85 | $31,669.25 | $32,619.33 | $33,597.91 | $34,605.85 | $342,300.74 |
Repairs and maintenance | $700.00 | $1,442.00 | $1,485.26 | $1,529.82 | $1,575.71 | $1,622.98 | $1,671.67 | $1,721.82 | $1,773.48 | $1,826.68 | $1,881.48 | $1,937.93 | $19,168.84 |
Security | $600.00 | $1,236.00 | $1,273.08 | $1,311.27 | $1,350.61 | $1,391.13 | $1,432.86 | $1,475.85 | $1,520.12 | $1,565.73 | $1,612.70 | $1,661.08 | $16,430.44 |
Sundries | $2,000.00 | $4,120.00 | $4,243.60 | $4,370.91 | $4,502.04 | $4,637.10 | $4,776.21 | $4,919.50 | $5,067.08 | $5,219.09 | $5,375.67 | $5,536.94 | $54,768.12 |
Superannuation | $1,500.00 | $3,090.00 | $3,182.70 | $3,278.18 | $3,376.53 | $3,477.82 | $3,582.16 | $3,689.62 | $3,800.31 | $3,914.32 | $4,031.75 | $4,152.70 | $41,076.09 |
Transport/courier costs | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
Wages | $10,000.00 | $20,600.00 | $21,218.00 | $21,854.54 | $22,510.18 | $23,185.48 | $23,881.05 | $24,597.48 | $25,335.40 | $26,095.46 | $26,878.33 | $27,684.68 | $273,840.59 |
Workers Compensation | $1,000.00 | $2,060.00 | $2,121.80 | $2,185.45 | $2,251.02 | $2,318.55 | $2,388.10 | $2,459.75 | $2,533.54 | $2,609.55 | $2,687.83 | $2,768.47 | $27,384.06 |
Total | $37,800.00 | $77,867.00 | $80,203.01 | $82,609.10 | $85,087.37 | $87,639.99 | $90,269.19 | $92,977.27 | $95,766.59 | $98,639.59 | $101,598.77 | $104,646.74 | $1,035,104.63 |
Result | |||||||||||||
Net profit | -$1,800.00 | -$1,067.00 | -$39,883.01 | -$26,161.10 | -$6,060.17 | $22,998.09 | $64,624.12 | $123,873.37 | $207,824.30 | $326,387.66 | $493,439.37 | $728,406.67 | $1,892,582.30 |
Gross profit margin | 64% | 76% | 29% | 29% | 29% | 29% | 29% | 29% | 29% | 29% | 29% | 29% | 29% |
Net profit margin | -3% | -1% | -28% | -13% | -2% | 6% | 12% | 16% | 20% | 22% | 24% | 25% | 19% |
Assumptions made for the income statement
An assumption is made that the company will start running at a loss in the first five months. This is so because the business will be new in the market, and not many customers will recognize it. However, the sales revenue will grow with time, and the company will report a positive net profit margin in the sixth month and continue with a growing trend. Further, the business’s operations assume a lower inflation rate and a stable economy. Notably, the income statement is justified based on these assumptions.
Pro-forma cash budget
Cash forecast | |||||||||||||
Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Totals | |
Starting cash position | $70,000.00 | $141,780.00 | $185,502.70 | $260,394.70 | $385,525.40 | $582,652.70 | $903,961.98 | $1,377,017.27 | $2,060,132.80 | $3,050,530.92 | $4,449,858.79 | $6,447,304.21 | |
Cash inflow | |||||||||||||
Cash sales | $112,000.00 | $100,800.00 | $141,120.00 | $197,568.00 | $276,595.20 | $387,233.28 | $542,126.59 | $758,977.23 | $1,062,568.12 | $1,487,595.37 | $2,082,633.52 | $2,915,686.92 | $10,064,904.23 |
Collections from accounts receivable | $0.00 | ||||||||||||
Other cash receipts | $0.00 | ||||||||||||
Total | $112,000.00 | $100,800.00 | $141,120.00 | $197,568.00 | $276,595.20 | $387,233.28 | $542,126.59 | $758,977.23 | $1,062,568.12 | $1,487,595.37 | $2,082,633.52 | $2,915,686.92 | $10,064,904.23 |
Cash outflows | |||||||||||||
Fixed costs | $18,900.00 | $38,933.50 | $40,102.00 | $50,104.00 | $48,287.00 | $42,125.00 | $45,900.00 | $50,000.00 | $49,800.00 | $51,211.00 | $52,398.00 | $50,763.00 | $538,523.50 |
Administration | $18,900.00 | $38,933.50 | $40,102.00 | $50,104.00 | $48,287.00 | $42,125.00 | $45,900.00 | $50,000.00 | $49,800.00 | $51,211.00 | $52,398.00 | $50,763.00 | |
Marketing | |||||||||||||
Operations | |||||||||||||
Variable costs | $21,320.00 | $18,143.80 | $26,126.00 | $22,333.30 | $31,180.90 | $23,799.00 | $23,171.30 | $25,861.70 | $22,370.00 | $37,056.50 | $32,790.10 | $30,290.60 | $314,443.20 |
Administration | $11,788.00 | $10,100.00 | $11,677.00 | $12,333.00 | $22,000.00 | $10,949.00 | $10,654.00 | $11,455.00 | $11,544.00 | $16,599.00 | $14,366.00 | $13,660.00 | |
Marketing | $4,532.00 | $3,488.00 | $6,563.30 | $5,467.80 | $4,490.90 | $6,400.00 | $6,542.00 | $7,865.60 | $1,276.50 | $12,902.50 | $11,523.50 | $7,896.80 | |
Operations | $5,000.00 | $4,555.80 | $7,885.70 | $4,532.50 | $4,690.00 | $6,450.00 | $5,975.30 | $6,541.10 | $9,549.50 | $7,555.00 | $6,900.60 | $8,733.80 | |
Total | $40,220.00 | $57,077.30 | $66,228.00 | $72,437.30 | $79,467.90 | $65,924.00 | $69,071.30 | $75,861.70 | $72,170.00 | $88,267.50 | $85,188.10 | $81,053.60 | $852,966.70 |
Result | |||||||||||||
Change during month | $71,780.00 | $43,722.70 | $74,892.00 | $125,130.70 | $197,127.30 | $321,309.28 | $473,055.29 | $683,115.53 | $990,398.12 | $1,399,327.87 | $1,997,445.42 | $2,834,633.32 | |
Closing cash position | $141,780.00 | $185,502.70 | $260,394.70 | $385,525.40 | $582,652.70 | $903,961.98 | $1,377,017.27 | $2,060,132.80 | $3,050,530.92 | $4,449,858.79 | $6,447,304.21 | $9,281,937.53 |
Assumptions made for the cash budget
It is assumed that the company will manage to collect its account receivables in a period of fewer than two months. Also, it is assumed that an increasing trend in company performance will be maintained across the year and thus achieve the anticipated cash position across the 12 months. Notably, the cash budget is justified by the stable economic conditions that exist in the region.
Tangible and intangible cost of capital
The business setup will require tangible and intangible capital costs. As the income statement shows, bank interest and charges are the tangible cost of capital. They represent the additional costs to be incurred by the company pending the capital that is acquired (Caggese & Pérez-Orive, 2022). The bank loan obtained as borrowings indicated in the proforma balance sheet will be paid with the additional interest expenses. Further, bank charges will be incurred in processing the loan. There are no other tangible costs related to the capital since the owner will raise the other funding required. However, intangible costs will be incurred regarding the debt capital used to fund the business. The intangible costs are related to debt capital and owners’ equity.
Regarding debt capital, intangible costs will be accumulated for the period incurred while waiting for the loan to be processed. Regarding owners’ equity, the intangible costs are related to the opportunity costs missed by the funds invested in the business instead of a different one. Notably, the costs are insignificant compared to the anticipated profits, and thus, the funding source is justified.
How to grow the business in the next five years
Assuming the business has been operating profitably for five years, certain measures would be considered to ensure more growth is achieved in the next five years. First, the business will consider returning earnings into business activities to enhance service delivery. For instance, retained earnings will be used to open more business branches in the region, which in turn will boost the company’s profit levels. Another way to ensure the business remains successful and strong in the next five years is by creating a superior brand name. Essentially, this is so because a superior brand name will ensure customers remain loyal to our business and even bring in new customers. One way to boost the business brand name is through offering exemplary services to our customers.
Various aspects will also be considered while undertaking an equity approach to valuing the business in the next five years. The company will aim to be listed on the stock exchange so its stock can be publicly traded. By doing so, various aspects, such as market price per share, will be used to value the company. However, before the company is listed on the stock exchange, the book value, which represents the equity owned by shareholders, will be used to evaluate the company. The value will be obtained from the annual balance sheet by subtracting total liabilities from the company’s assets (Pinto et al., 2019). Also, an earnings multiplier will be considered in the equity approach, whereby company profits will depict the company’s real value.
References
Caggese, A., & Pérez-Orive, A. (2022). How stimulative are low real interest rates for intangible
Capital? European Economic Review, 142, 103987.
Pinto, J. E., Robinson, T. R., & Stowe, J. D. (2019). Equity valuation: A survey of professional
Practice. Review of financial economics, 37(2), 219-233.
ORDER A PLAGIARISM-FREE PAPER HERE
We’ll write everything from scratch
Question
Overview: (Please see attached previous assignments for reference)
Using the same business you started in the first assignment, Your Business Venture, you will continue to build a financial plan for the business.
Instructions
Write a 4–5 page paper in which you:
Prepare a pro forma balance sheet for the first 12 months of your business. Include the assumptions on which it is based. Justify your balance sheet.
Prepare a pro forma income statement for the first 12 months of your business. Include the assumptions on which it is based. Justify your income statement.
Prepare a pro forma cash budget for the first 12 months of your business. Include the assumptions that you have made when creating the budget. Justify your budget.
Scrutinize tangible and intangible costs of obtaining financial capital for your business start-up to determine whether the costs justify the implementation of the funding source.
Assume your business is five years old and running profitably and consider how you would grow your business over the next five years.
Determine the specific details that would make the equity approach to valuing your business worthwhile. Provide a rationale with your response.
This course requires the use of Strayer Writing Standards. For assistance and information, please refer to the Strayer Writing Standards link in the left-hand menu of your course. Check with your professor for any additional instructions.
The specific course learning outcome associated with this assignment is:
Assess whether the costs of obtaining capital for a business justify the use of the funding source and whether the equity-based valuation of the business is appropriate.