Need Help With This Assignment?

Let Our Team of Professional Writers Write a PLAGIARISM-FREE Paper for You!

Beyond-Wash & Auto detailing Industry

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 Review142, 103987.

Pinto, J. E., Robinson, T. R., & Stowe, J. D. (2019). Equity valuation: A survey of professional

Practice. Review of financial economics37(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.

Beyond-Wash & Auto detailing Industry

Beyond-Wash & Auto detailing Industry

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.