Need help with an accounting question. Thanks Business Applications Case Prepari
ID: 2715599 • Letter: N
Question
Need help with an accounting question. Thanks
Business Applications Case Preparing and using pro forma statements
Mary Helu and Randy Adams recently graduated from the same university. After graduation they decided not to seek jobs at established organizations but, rather, to start their own small business hoping they could have more flexibility in their personal lives for a few years. Mary's family has operated Mexican restaurants and taco-trucks for the past two generations, and Mary noticed there were no taco-truck services in the town where their university was located. To reduce the amount they would need for an initial investment, they decided to start a business operating a taco-cart rather than a taco-truck, from which they would cook and serve traditional Mexican-styled street food.
They bought a used taco-cart for $16,000. This cost, along with the cost for supplies to get started, a business license, and street vendor license brought their initial expenditures to $22,000. Ten-thousand dollars came from personal savings they had accumulated by working part time during college, and they borrowed $20,000 from Mary's parents. They agreed to pay interest on the outstanding loan balance each month based on an annual rate of 5 percent. They will repay the principal over the next few years as cash becomes available. They were able to rent space in a parking lot near the campus they had attended, believing that the students would welcome their food as an alternative to the typical fast food that was currently available.
After two months in business, September and October, they had average monthly revenues of $20,000 and out-of-pocket costs of $15,000 for rent, ingredients, paper supplies, and so on, but not interest. Randy thinks they should repay some of the money they borrowed, but Mary thinks they should prepare a set of forecasted financial statements for their first year in business before deciding whether or not to repay any principal on the loan. She remembers a bit about budgeting from a survey of accounting course she took and thinks the results from their first two months in business can be extended over the next 10 months to prepare the budget they need. They estimate the cart will last at least three years, after which they expect to sell it for $4,000 salvage value. Mary agrees to prepare a forecasted (pro forma) income statement, balance sheet, and statement of cash flows for their first year in business, including the two months that have already passed.
Required:
1. Prepare a pro forma income statement for the company based on Mary's comments about her expectations for the business. (You may want to prepare all of your statements using Excel and then upload them.)
2. Prepare a pro forma balance sheet for the company based on Mary's comments about her expectations for the business. Assume no principal will be repaid on the loan in the current year.
3. Prepare a pro forma statement of cash flows for the company based on Mary's comments about her expectations for the business.
4. Review the statements you prepared and explain briefly why actual results for Randy and Mary's business probably will not match their budgeted statements.
Explanation / Answer
Ans 4
Ans 1 Pro forma income statement Details Details Amount Sales Average monthly revenue*12 2,40,000.00 Cash Operating cost -1,80,000.00 Cash Profit 60,000.00 Less Depreciation 16000-4000/3 -4,000.00 Operating cost -1,84,000.00 Operating Profit 56,000.00 Annual Interest 20000*5% -1,000.00 Net Profit 55,000.00 Ans 2 Proforma Balance Sheet Assets Net Current Assets Bf 67,000.00 Equipment 16000-4000 12,000.00 Business Licnece & Others 6,000.00 Total Fixed assets 18,000.00 Total Assets 85,000.00 Laibility and Equity Loan 20,000.00 retained Earnings 55,000.00 Equity Stock 10,000.00 Total Equity 65,000.00 Total Liability and Equity 85,000.00 Ans 3 Cash flow Statement NetProfit 55,000.00 Add:Depreciation 4,000.00 Cash from Operations before WC 59,000.00 Less : Increase in Net current Assets 67,000.00 Cash from Operations -8,000.00 Purchase of Equipment and business licnece -22,000.00 Cash used in Investing activities -22,000.00 Equity Contribution 10,000.00 Loan taken 20,000.00 Cash from Financing activities 30,000.00 Net Movement in Cash and cash equivalents -