Question

In: Accounting

ATC 14-1 Business Applications Case Preparing and using pro forma statements Maria Gutierrez and Devin Duzan...

ATC 14-1 Business Applications Case Preparing and using pro forma statements

Maria Gutierrez and Devin Duzan 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. Maria’s family has operated Mexican restaurants and taco trucks for the past two generations, and Maria 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 $25,000. This cost, along with the cost for supplies to get started, a business license, and street vendor license brought their initial expenditures to $29,000. They took $5,000 from personal savings they had accumulated by working part-time during college, and they borrowed $15,000 from Maria’s parents. They agreed to pay interest on the outstanding loan balance each month based on an annual rate of 4 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 $16,000 for rent, ingredients, paper supplies, and so on, but not interest. Devin thinks they should repay some of the money they borrowed, but Maria 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 five years, after which they expect to sell it for $5,000 and move on to something else in their lives. Maria agrees to prepare a forecasted (pro forma) income statement, balance sheet, and statement of cash flows for their first year in business, which includes the two months already passed.

Required

  1. Prepare the annual pro forma financial statements that you would expect Maria to prepare based on her comments about her expectations for the business. Assume no principal will be repaid on the loan. [Note: Some amounts are different from the printed text version]
  1. Review the statements you prepared for the first requirement and prepare a list of reasons why actual results for Devin and Maria’s business probably will not match their budgeted statements.

Solutions

Expert Solution


Related Solutions

List the reasons for preparing pro forma financial statements from GAAP financial statements. What are typical...
List the reasons for preparing pro forma financial statements from GAAP financial statements. What are typical adjustments made to GAAP statements when preparing pro forma statements used in forecasting?
1.The authors set forth a seven-step forecasting game plan for preparing pro forma financial statements. Discuss...
1.The authors set forth a seven-step forecasting game plan for preparing pro forma financial statements. Discuss the seven steps necessary to prepare the three principal financial statements. 2.Sales numbers are determined by both a volume component and price component. Projecting prices depends on factors specific to the firm and its industry that might affect demand and price elasticity. Discuss whether it would be likely that the firm would be able to raise future prices for different types of business. 3.As...
Forecast the Pro forma Financial Statements for Company C using the % of Sales Method assuming:...
Forecast the Pro forma Financial Statements for Company C using the % of Sales Method assuming: sales increase by $100,000 in 2017; the company must increase Fixed Assets to $200,000 to support the higher level of production; all new financing will come from additional debt, and the payout ratio, the effective tax rate, and the rate of interest on debt will remain unchanged from 2016. Based on two iterations, what do you forecast for the amount of debt and the...
ATC 15-1 Business Applications Case   Static versus flexible budget variances David Catrow is the manufacturing production...
ATC 15-1 Business Applications Case   Static versus flexible budget variances David Catrow is the manufacturing production supervisor for Faraday Motor Works (FMW), a company that manufactures electrical motors for industrial applications. Trying to explain why he did not get the year-end bonus that he had expected, he told his wife, “This is the dumbest place I’ve ever worked. Last year the company set up this budget assuming it would sell 150,000 units. Well, it sold only 140,000. The company lost...
ATC 8-4 Business Applications Case Performing ratio analysis using real-world data American Greetings Corporation manufactures and...
ATC 8-4 Business Applications Case Performing ratio analysis using real-world data American Greetings Corporation manufactures and sells greeting cards and related items such as gift wrapping paper. CSX Corporation is one of the largest railway networks in the nation. The following data were taken from one of the companies’ February 29, 2016, annual report and from the other’s December 30, 2016, annual report. Revealing which data relate to which company was intentionally omitted. For one company, the dollar amounts are...
Case Study 2 Master Budgeting and Pro-Forma Financial Statements You have just been assigned to a...
Case Study 2 Master Budgeting and Pro-Forma Financial Statements You have just been assigned to a new manager who believes you have exceptional budgeting skills. Since you began your job last summer, you have been showing management your latest spreadsheets and how you use your new-found knowledge of Managerial Accounting to make sound business decisions. Your new manager is responsible for the nationwide distribution of designer handkerchief sets (HCS) and, through multiple franchise agreements, sales have grown very rapidly, and...
LUKE’S HOLIDAY SUPPLIES, INC. Pro Forma Statements Problem A)        1.             Income Statement           &nbs
LUKE’S HOLIDAY SUPPLIES, INC. Pro Forma Statements Problem A)        1.             Income Statement                                                          Balance Sheet                              Year Ended 2018                                                              12/31/18             Sales                                               $12,520                Cash                                                    $   110             Cost of Goods Sold                            9,698                Marketable Securities                            360             Gross Profit                                        2,882                Accounts Receivable                            2,220             Expenses                                            1.594                Inventory                                            3,210             Earnings Before Interest and Tax      1,228                    Total Current Assets                       5,900             Interest                                                  278 Earnings Before Tax                           950    Property/Plant/Equipment       4,730             Tax (40%)                                           380...
LUKE’S HOLIDAY SUPPLIES, INC. Pro Forma Statements Problem A)        1.             Income Statement           &nbs
LUKE’S HOLIDAY SUPPLIES, INC. Pro Forma Statements Problem A)        1.             Income Statement                                                          Balance Sheet                              Year Ended 2018                                                              12/31/18             Sales                                               $12,520                Cash                                                    $   110             Cost of Goods Sold                            9,698                Marketable Securities 360             Gross Profit                                        2,882                Accounts Receivable 2,220             Expenses                                            1.594                Inventory 3,210             Earnings Before Interest and Tax      1,228                Total Current Assets 5,900             Interest                                                  278 Earnings Before Tax                           950                Property/Plant/Equipment       4,730             Tax (40%)                                           380                Accumulated Depreciation     680            ...
Create pro forma financial statements from the information provided below Year 1 Sales revenues increase 3.0%...
Create pro forma financial statements from the information provided below Year 1 Sales revenues increase 3.0% Gross margin is 47% SG&A decreases by 3.0% $2000 of PP&E is purchased on January 1, New PP&E is depreciated over 10 years Inventory grows in line with COGS Assume that all other asset accounts grow in line with sales (3.0%). Accounts Payable grow in line with COGS Accrued and deferred income taxes grows in line with tax expense. Long-term debt increases by $500...
PART 1: Using Excel, create a 5-year annual pro forma income statement for the newly formed...
PART 1: Using Excel, create a 5-year annual pro forma income statement for the newly formed Ranger Corporation based on the information provided below. Be sure to place all key assumptions at the top of your spreadsheet (not within the statement), so that you can perform a "what-if" analysis based on changing the base assumptions. In the event that you choose not to use the template included in this workbook (I have provided a "template you can use for this...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT