module 7 case

docx

School

Baker College *

*We aren’t endorsed by this school

Course

3110

Subject

Accounting

Date

Feb 20, 2024

Type

docx

Pages

4

Uploaded by ColonelInternetStarling35

Report
Brian Nieves Baker College BUS3110-C1 Module 7: Case Application
ATC 14-1 pg. 534-535 a. Annual pro forma financial statements Taco Cart Budgeted Financial Statement Statement of Cash Flows Operating Activities Inflow from sales 240000 Outflows supplies -192000 licenses -5000 Interest EXP -600 Net Cash 42400 Investing Activities OF purchse of cart -15000 Net Cash -15000 Financinig Activity Capital 5000 loan 15000 Net Cash 20000 Net +/- 47400 Beginning cash 0 End cash 47400 Taco Cart Budgeted financial statement Income Statement Revenue Calculations Sales 240000 12 x 20000 Total 240000 Expenses License and support 5000 20000-15000 Operating cost 192000 12 x 16000 Interest 600 15000 x .04 Depreciation 2000 (15000 - 500 Total 199600 Net income 40400 Taco Cart Budgeted Financial Statements Balance Sheet Cash 47400 Cart 15000 Acc. Dep. -2000 Total Assets 60400 Note Payable 15000 Capital 5000 Ret. Earning 40400 Total Liability & Equity 60400 b. The budgeted statements are an assumption that sales will stay exactly the same for the month of the year. The is a food truck business and weather is a major factor that must be considered. The colder months might bring in less sales because people are least likely to be eating out at a food truck in the cold. There is also the matter of the initial expense in starting the business. There may be annual licensing fees but some of the other might not be a recurring expense. This
would be a financial positive. This budget also doesn’t factor in money taken out by the owners. They will need to draw funds for everyday living expenses. Chapter 15 ATC 15-4 pg. 569 2014 FY Europe Pacific Segment icome 1084 2852 2316 2447 2448 Identifiable Assets 1298 3358 2426 33066 1793 Return on Investment 83.51% 84.93% 95.47% 7.40% 136.53% Reesidual Income 694.6 1844.6 1588.2 -7472.8 1910.1 2013 FY Segment icome 1087 2859 2908 2432 2478 Identifiable Assets 1273 3731 2918 33964 1922 Return on Investment 85.39% 76.63% 99.66% 7.16% 128.93% Reesidual Income 705.1 1739.7 2032.6 -7757.2 1901.4 Eurasia & Africa Latin America North America a. The data above shows that the Pacific segment has the best ROI for 2014. The European segment had the most improvement with an 8.3% increase. The Pacific came in a close 2 nd with a 7.6% increase in ROI. b. After computing the residual income of each segment, the Pacific had the highest with a $1,910.10 in both 2014 and 2103. The segment that improved the most from 2013 to 2014 was Europe with a $104.90 increase in residual income. c. In 2013, The Pacific had the highest ROI of 128.93%, which is higher than Latin America’s 99.66%. Even though the ROI was higher the residual income was lower and this could be due to more identifiable assets in Latin America. d. Based on ROI alone the Pacific segment seems to provide a consistently high return. A decision like this should not be solely based on ROI. The European segment doesn’t have the highest but it is the most improved from year to year. Latin America also sees to have growth potential. There are non-quantitative factors in pay here that should also be considered.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Reference Edmonds, T., Edmonds, C., Olds, P., McNair, F., & Tsay, B. (2018).   Survey of Accounting - Fifth Edition.   New York: McGraw-Hill Education.