Question

In: Accounting

Business Plan – toy merchandise sales Invest $150,000 cash savings for capital equipment and "working capital....

Business Plan – toy merchandise sales

Invest $150,000 cash savings for capital equipment and "working capital. "

Buy Capital Equipment (vehicle of transportation, computer, storage unit) during organizing period for business $50,000

Buy toy units (1 type only) for cash on delivery - $3/unit after receiving bulk order for toy units

Additional variable cost per unit for fuel, labor, packaging, transportation, etc to deliver toys to retailer is $2/unit

Average time from order to delivery is 1 month

Rent, Utilities, Insurance, Bookkeeping, etc (fixed costs) - $12,000/month

Sell packaged, and delivered toy units to retailer for $9/unit

Average time from delivery until when retailer pays is 3 months (Typical "Net 90" Payment Terms)

Sales prediction:

Assume steady orders and sales of 1000 units per month, first sale in January, first delivery in February, first payment received in May, and so on.

Required:

Prepare monthly preliminary income statement and cash flow statement for the first year in spreadsheet (feel free to use any spreadsheets we developed during the class)

Determine if there are any external funding requirements

What are the business’s profit margin, return on assets, debt to assets, debt to equity, and asset to equity ratios?

According to the integrated reporting framework, what kind of capitals are the most relevant in this business context?

Calculate the sustainable growth rate for the business at the end of year 1

Recommend two dynamic metrics for this business and explain briefly why.

Solutions

Expert Solution

1. Monthly income statement
January Feburary March April May June July August September Octomber November December For year
Incomes
Sales (1000*9) $9,000 $9,000 $9,000 $9,000 $9,000 $9,000 $9,000 $9,000 $9,000 $9,000 $9,000 $9,000 $108,000
Expences
Fixed cost ($12,000) ($12,000) ($12,000) ($12,000) ($12,000) ($12,000) ($12,000) ($12,000) ($12,000) ($12,000) ($12,000) ($12,000) ($144,000)
Purchase cost (3*1000) ($3,000) ($3,000) ($3,000) ($3,000) ($3,000) ($3,000) ($3,000) ($3,000) ($3,000) ($3,000) ($3,000) ($3,000) ($36,000)
Additional variable cost (2*1000) ($2,000) ($2,000) ($2,000) ($2,000) ($2,000) ($2,000) ($2,000) ($2,000) ($2,000) ($2,000) ($2,000) ($2,000) ($24,000)
Profit/(Loss) ($8,000) ($8,000) ($8,000) ($8,000) ($8,000) ($8,000) ($8,000) ($8,000) ($8,000) ($8,000) ($8,000) ($8,000) ($96,000)
2. Cash flow statement
January Feburary March April May June July August September Octomber November December For year
Cash inflows
Investment $150,000 $150,000
money received from sales $9,000 $9,000 $9,000 $9,000 $9,000 $9,000 $9,000 $9,000 $72,000
Cash outflows
Buy capial eqipments ($50,000) ($50,000)
Fixed cost ($12,000) ($12,000) ($12,000) ($12,000) ($12,000) ($12,000) ($12,000) ($12,000) ($12,000) ($12,000) ($12,000) ($12,000) ($144,000)
Cash pay on delivery ($3,000) ($3,000) ($3,000) ($3,000) ($3,000) ($3,000) ($3,000) ($3,000) ($3,000) ($3,000) ($3,000) ($33,000)
Variable cost for delivery ($2,000) ($2,000) ($2,000) ($2,000) ($2,000) ($2,000) ($2,000) ($2,000) ($2,000) ($2,000) ($2,000) ($22,000)
Net cash inflow/outflow $88,000 ($17,000) ($17,000) ($17,000) ($8,000) ($8,000) ($8,000) ($8,000) ($8,000) ($8,000) ($8,000) ($8,000) ($27,000)
2. Yes. Company need to facilitate loan fund. Because company Asset< Capital. Also company is runing in heavy loss thoughout the year and faced huge amount of cash deficit @ the year end.
3. Profit margin = (Net profit or loss / sales)*100 =( -96,000/108,000)*100 = -88.88%
return on asset = Net income / Total assets = -96,000/50,000+*36,000) = -1.12          *Here 36,000 mean Debtors. Money that should received from the debtors ( 9,000*4)
Debt to asset ratio = Debt /asset = 27,000+*3,000/50,000+36,000 = 0.35 here 3,000 mean creditors. Payment required for goods purchased.
debt to eqity ratio = Debt / Eqity = 30,000/ 150,000-96,000) = 0.55
Assdet to eqity ratio = Asst / Equity = 86,000/54,000 = 1.6
4. Working capitals are the more relevant type of capital is reqired for these type of business contest. Since this is merchandise company lot of sales and purchases need to be done in day to day. Therefore huge amount of working capital reqired to carry out business process efficently.

Related Solutions

Business Plan – toy merchandise sales Invest $150,000 cash savings for capital equipment and "working capital....
Business Plan – toy merchandise sales Invest $150,000 cash savings for capital equipment and "working capital. " Buy Capital Equipment (vehicle of transportation, computer, storage unit) during organizing period for business $50,000 Buy toy units (1 type only) for cash on delivery - $3/unit after receiving bulk order for toy units Additional variable cost per unit for fuel, labor, packaging, transportation, etc.. to deliver toys to retailer is $2/unit Average time from order to delivery is 1 month Rent, Utilities,...
purchases and Sales of Merchandise, Cash Flows Pedal City, a bike shop, opened for business on...
purchases and Sales of Merchandise, Cash Flows Pedal City, a bike shop, opened for business on April 1. It uses a periodic inventory system. The following transactions occurred during the first month of business: Required: For all accounting equations, if a financial statement item is not affected, select "No Entry" and leave the amount box blank or enter "0". If the effect is negative, use the minus sign. Remember: if a contra account is increased, it will have the effect...
Aerospace Dynamics will invest $150,000 in a project that will produce the following cash flows. The...
Aerospace Dynamics will invest $150,000 in a project that will produce the following cash flows. The cost of capital is 10 percent. (Note that the fourth year’s cash flow is negative.) Use Appendix B for an approximate answer but calculate your final answer using the formula and financial calculator methods.    Year Cash Flow 1 $ 45,000 2 57,000 3 65,000 4 (48,000 ) 5 140,000 a. What is the net present value of the project?
An investment in an item of equipment would cost GH¢150,000. It is estimated that sales in...
An investment in an item of equipment would cost GH¢150,000. It is estimated that sales in the first year would be GH¢120,000 rising by 10% a year for the next four years. Variable costs would be 50% of sales. Annual fixed costs would be GH¢40,000 in the first three years, rising to GH¢60,000 in years 4 and 5. Fixed costs of 60% would be avoidable if the project did not go ahead. The scrap value of the equipment at the...
Question 2 You plan to invest part of your savings and are examining the following data:...
Question 2 You plan to invest part of your savings and are examining the following data: Expected Return Beta Yield to maturity on 10-year government bonds 2% Stock A 20% 1.3 Stock B 9% 1.1 Stock C 7% 0.5 Portfolio D 10% 1.0 (a) If only Portfolio D is correctly priced, are stocks A, B and C correctly priced? If not, what investment action would you recommend for each stock to take advantage of the price anomaly? (b) Company X...
What is working capital and how do businesses use working capital to manage a business?
What is working capital and how do businesses use working capital to manage a business?
BRAND purchased equipment for $290,000 cash, sold equipment costing $150,000 with a book value of $100,000,...
BRAND purchased equipment for $290,000 cash, sold equipment costing $150,000 with a book value of $100,000, and declared and paid dividends during 2021. No new notes payable were issued during the year. Financial data follows.  All balances are normal.   Balance Sheet Dec. 31, 2021 Dec. 31, 2020 Change Cash $  36,000 $29,000 $  7,000 Accounts receivable   125,000 97,000 28,000 Inventory    100,000 114,000 (14,000) Equipment 740,000 600,000 140,000 Accum. depreciation 370,000 220,000 150,000 Accounts payable 170,000 150,000 20,000 Unearned revenue 74,000 44,000 30,000 Accrued...
BRAND purchased equipment for $290,000 cash, sold equipment costing $150,000 with a book value of $100,000,...
BRAND purchased equipment for $290,000 cash, sold equipment costing $150,000 with a book value of $100,000, and declared and paid dividends during 2021. No new notes payable were issued during the year. Financial data follows.  All balances are normal.   Balance Sheet Dec. 31, 2021 Dec. 31, 2020 Change Cash $  36,000 $29,000 $  7,000 Accounts receivable   125,000 97,000 28,000 Inventory    100,000 114,000 (14,000) Equipment 740,000 600,000 140,000 Accum. depreciation 370,000 220,000 150,000 Accounts payable 170,000 150,000 20,000 Unearned revenue 74,000 44,000 30,000 Accrued...
Firm W has the opportunity to invest $150,000 in a new venture. The projected cash flows...
Firm W has the opportunity to invest $150,000 in a new venture. The projected cash flows from the venture are as follows. Year 0 Year 1 Year 2 Year 3 Initial investment $ (150,000) After-tax cash flow $ 5,000 $ 8,000 $ 10,000 Return of investment 150,000 Net cash flow $ (150,000) $ 5,000 $ 8,000 $ 160,000 a-1. Complete the below table to calculate NPV. Assume Firm W uses a 6 percent discount rate. Complete the below table to...
Working Capital Cash Flow Cycle Strickler Technology is considering changes in its working capital policies to...
Working Capital Cash Flow Cycle Strickler Technology is considering changes in its working capital policies to improve its cash flow cycle. Strickler's sales last year were $1,700,000 (all on credit), and its net profit margin was 5%. Its inventory turnover was 4.5 times during the year, and its DSO was 45 days. Its annual cost of goods sold was $900,000. The firm had fixed assets totaling $265,000. Strickler's payables deferral period is 51 days. Assume a 365-day year. Do not...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT