1.What is the profit margin on sales for 2014? Round the answer to the nearest whole percentage and show the percent (%) sign.

2.What is the current ratio for 2014?

3.What is the average collection period for 2014? Assume there are 365 "selling days" in the year. Show the answer rounded to the nearest whole number.

4.What is the fixed asset turnover for 2014?

5.The balance sheet (not shown in the excel document) as of 12/31/12 shows that Owner Equity was $798,918. If this amount were invested at 3% paid out annually for 40 years, what annual income would the investment produce? (Tip: His investment would be a "payment").

6.The following are options for increasing the return on Mr. Moore's retirement income (as calculated in number 5 ): Work a little longer, invest at a higher rate of return, sell the business for more (that is, increase "PV"), increase the number of years for which the money is invested, wait to become eligible for social security payments T/F

7.What is the Return on Equity for 2014?

8.What is the Return on Total Assets for 2014?

9.In your opinion is this a "viable business" that Mr. Moore can operate for "as long as he wants to"? Evaluate the business from 2009 to 2014 in the process of answering this question. Since this problem requires a financial analysis, I am including information about the answer choices you will encounter on the exam in Blackboard below:

1Yes, but into 2015 he should figure out how to make his company more cost and expense, efficient, so that ROS improves

2YES, but in 2015 he should be mindful of keeping total costs as a percent of sales under control

3YES, because Return on Sales has always been trending upwards

4NO, because Cost of Product continues to increase and Cost of Product as a % of sales is decreasing.

5NO, because income taxes are out of control

6Both 1 and 2

7Both 2 and 3

10.What is the net income figure to use as a starting point for the statement of cash flows?

11.The total adjustments to net income to determine cash flows from operating activitiesare......(Hint: be sure to add up changes in current assets and current liabilities as noted on the balance sheet going from year 2013 to year 2014) to get the answer.

12.Net cash flows from operating activities are....(hint: don't forget about net income).

13.Cash flows from investing activities are.....

14.Net Cash flows from investing activities are....

15.Cash flows from financing activities are...(hint: since this is a partnership common and preferred stocks and bond financing does not exist).

16.Net increase/decrease in cash flows is....

17. What is to be the Sales budget for 2015?

18. What is to be the Cost of Product for 2015?

19. What is to be the Labor budget for 2015?

20. What is to be the Benefits budget for 2015?

21. What is to be the Cost of Services for 2015?

22. What are Total Costs to be budgeted for 2015?

23. What are Earnings before Interest, Taxes and Depreciation (EBITD) to be for 2015?

24. Mr. Moore is considering selling the business at the end of 2015 for his Owners Equity (projected to be at least $1,825,684) and using that amount to buy an investment that would pay him 6% per year (paid annually in one payment) for 40 years. What would the annual payment from such an investment be?

25. Will the combination of investment return and Social Security payments described in the text of the case meet Mr. Moore's minimum retirement goals?

1)No, it will fall short of his goal by approximately $14,160

2)Yes, it exceeds his goal by approximately $14,160

3)Yes. It exceeds his goal by well over $40,000.

4)Not enough information to tell.

26. When he was 30 years old, about the time he took over the restaurant from his father, Mr. Moore bought an unusual insurance policy: it was in the form of a "zero coupon" bond. The bond paid 5% per year and guaranteed him $475,000 when it matured in 50 years. He paid a single premium amount and no further payments were necessary. What did Mr. Moore pay for the policy when he bought it? Hint: This is a problem in PV (present value).

27. Mr. More wants to get into the catering business, specifically by using his family's secret sauce recipe which can be used on any meat product (i.e. hamburgers, hotdogs, chicken, etc.). To transport food, he bought a small SUV as a delivery truck for $75,000. He financed it for 2 years at 12% and will make equal payments each month for the 6 years. What will the monthly payments be?

28. About the SUV that Mr. Moore was thinking of buying for $75,000.00 and financing at 12% for 2 years: When the vehicle is paid off, how much will have been paid for the truck?

29. When shopping to buy the SUV for a delivery truck, a competing dealer offered him two options to finance the purchase price of $65,000 for the same truck:

Cash Back Option - $10000 "Cash Back" and the balance paid in yearly installments at 5% (compound interest) per year for 5 years (to be applied as a downpayment to reduce the price)

Full Price Option - full price ($65,000) paid at no interest over 5 years.

Under which option will the truck cost the LEAST? Hint: Don't forget to take "cash back" into account.

1)Can't tell. Need more information about alternative investment and finance rates.

2)The "Cash Back" option

3)The "Full Price" option

4)Either option. They both produce the same result.

30. In your new position as head accountant (so OK - you're the only accountant but it will sound better on your resume) working for Mr. Moore, you note that last month on July 2, 2012 they bought "research equipment and certain special tools" for $60,000 (you don't want to know what they will do with those "special tools") anyway your job is to lower their corporate taxes if possible. So you decide to use MACRS for depreciation and you want to see if there is any possible depreciation that could be used.How much can they take for these years listed below?

2012, 2014, 2015, 2017.

31. Mr. Moore was thinking of taking a vacation and going to the Sun Highway in Glacier National Park - located in northwestern Montana - since it is one of the most spectacular drives in North America.Unfortunately he found out from some relatives in the area that the road needs to be resurfaced due to many harsh winters. Him being the finance wizard that he is, he was thinkint about how the state would finance such a project with bonds. If the State of Montana has decided to sell state bonds to cover the needed repairs,A Montana state savings bond can be converted to $100 at maturity six years from purchase.If the state bonds are to be competitive with U.S. savings bonds, which pay 8% annual interest (compounded annually), at what price must Montana sell its bonds?(Assume no cash payments on savings bonds prior to redemption.)

32. Mr. Moore is thinking about how much the return of Apple stock could be given it's beta of 1.11 for a possible investment he wants to make.Other data you have collected:the rate of return on 90 day T-Bills is 1.5%, on 5 year T-Notes it 3% and on the "long bond", the 30-year T- Bond = 6.5%.The Prime is 6%, LIBOR is 5.5% and the average return on the overall stock market is estimated to be 8%.After doing some research and crunching the numbers what would Mr. Moore expect the rate of return on Apple's stock to be?Hint:note that term "beta" - there's a classic formula that uses "beta"!

33. Mr. Moore plans on replacing and/or upgrading the furniture, fixtures and machinery (stoves, refrigerators, AC, etc) in 10 years when it's expected to wear out at the end of its useful life. The estimated replacement cost is $350,000. How much must the company save each year at 3% to accumulate enough to replace the machine? (Hint: Switch "mental gears" to TVM?)

E insert Page Law-Ht Friiinulas M: 12'; Spreadshi , Final IE] ' izarneatihilin- M Sign in 2" EX?\" (alion v H 7 Wv Erwiaoieia General v E '2' Normal 2 Normala Normal Bad Good em $ 3': ZAutosiirn v 1th p Fame 332* \"my 3 I H v 7 V - Mag: 5, Gem, , 3 , 96 , (-ng $2 Candmorlil Format as Neutral Calculaliun EprDH any input : insert Delete meat E's\" V Son at Flnd 81 . Formalng' Table' v v . ~ '9' Filtcl' Seleetv Cllulmam l1 Film: l1 Alignment l'ii Numbu l1 Style: Cell: Editing J19 ' E r B lclnlElr [GlHIJK]LlMlNlDlP|QlRl5l1lU|Vl\\E Moores Familay Restaurant Financial Dala 2013 2014 (Present Day] 2015 Budget Forecast budget Worlsgtieet sales $1,575,396 $1,596,295 Answer to number 17 Cost of Product $597,211 $597,211 Answer to number 13 Labor $330,772 $340,595 Answer to number 19 Benefits $79,872 $114,519 Answer to number 20 utilities $54,340 $50,544 $55, 241 Loan Principle Repayments $0 $0 $0 insurance & PropertyTaxes $110,000 $110,000 $110,000 services (accounting, trash, cleaning, etc.) $41,051 $43,903 Answer to number 21 other: 55 EA, advertising, promostions $77,529 $34,771 $93,243 Tolal Costs $1,390,575 $1,341,745 Answer to number 22 Earnings Belore Interest, lncomenxes, & Depreciation (EBIID) $134,521 $354,543 Answer to number 23 interest on loan $3,500 $3,000 $3,000 income Taxes $51,ono $93,273 ' WALIJE! Depreciation on values $71,175 $51,777 $51,177 Earnings Alter interest, Income taxes, at Depreciation $53,179 $190,497' WALIJE! MESIESDId 233,332 242,328 261,714 Average Mealvalue 5.75 7.00 7.35 lgW3laIEWW3lgWE?l5IRWWWl\"W5'5'55l:l5I\"l5WWl5|5ll'|\"l'\"l"'l\"l\"'l\"l\" L 315nm E M: 1555555155 [5115501110550 . , L-. mm " 3\": (5m v H . A' 1' E'wmrm 55150 v E '2' Narmalz Normala Normal Bad Good *EE' , 3': Exmw ' '2\"! p 55515 ER)\" 1 H v 7 : - Magda,\" , 3 , 9(1 , (-ng :3 (landmonal Formmas Neutral Calculaliun EprEmfDW Input : 'nxrt Dem meat ' ' mm mm . With\"? Formamg' Tah'e' v v . ~ 5'55" New sdmv 0.5555111 r. Punt r. Ahgnmenl r. Numbu r. 5mg; CeH: Emlmg C114 ' . fr v 4,1'a' c 0 5'5 G H\\||J\\K\\L\\M\\N|O\\PQ'\\S|Y\\u\\V\\W\\X\\V\\ZE L L Mama's FamW 5551501511 5_ mm 5 Link rs 5151mm tn 12/51/14 L 5_ was was 5_ cm 5192,11500 Cash 555911500 7_ Amounts Reteivahle 52900000 10:00an Retrivablr 51909500 3 Invenmnes $30,000,110 Irwrnmries 530,000,130 9' mum mam; 52.00000 mom Expense: 51100000 1? Imalcumnmsms 5555,11500 rmalcummnssms 557931500 1T 1T 51 mg 5727,0509: Building 575000000 1? Enulnment 514,500,00 Enulpmant 515,000,00 ? Fixture; 555,520,00 Fixture; 555,500,00 Y 1? 1.11.5: i155 055215 5175,25097 11ml Filed Assets 551550000 17 1? Imamssm 51,525,595 97 Tmalmm 51,092,715 00 1? 2? mamas unmmas 27 Mmuntswavable 557,052,00 Attuuntswavable 515755500 2? Wages and 55mm; Due 515,515,219 Wages and Benets Due 529,505,00 2? Bllmated 1515; and Fees 55,015 00 Btimated 15155 and Fees 55,015,00 27 TMaIEurrent u; ' 579,951 59 Tmalcurrent liah 'es 5175,12200 2? 23 lung term man 510,000,00 Langlerm man 510,000,00 E Total Langrmm liabilnizs $70,000.00 rml LunarTerm liablll'ies $70,000.00 21 23 53 DwnrrEquitv $1,175,037.35 own=rEquitv $1,247,591.00 51 31 amownermuilv 51,525,59597 15ml Liah rsandeErEV 51,492,71500 51 31 31 55 57 5? 5? 4? AT 47 ,3 v 4 (a 1 . E E -r+ m 5 Q 8 here to seat '7 E M: li'sipriadshi . . -. . gignin mm pagan,\" meula; . , 0 rein. " EX?\" (3min vii 7 Wv EnWrame Pementage v E '2' N5rmal2 Normal4 Normal Bad Good em $ 3': 255mm,,\" v 12;" p Page ECO\" B I H v 7 V -Ma'acm , 3 , 95 , (-ng :3 Candmclrlil Formaras Neutral Calculaliun EprDmImW rnpur : inm Dele Format mm Sana 5mm . "mehmr g Formamg' Table' v v . ~' 0\"" FilmvSeledv Cllulmam r. Punt r. Alignment r. Numbu r. 55m Cell: Editing a 521 v 5 :[FZLCZIJ/CZI v A a lClDlElF'G'H||lJlKlLlM|NlOlPlQlR|5lTlLllVlW|XlE L L Memes Familay Restaurant Financial Dala Historic Perlorrna nce [Old Business Mod ell % cha nge ilncomel-prensestatement 2009 201a 2011 2012 20002012 LSEIES $1,794,000 $1,577,120 $1,535,750 51,520,050 79.70% itaslofpmduct $485,000 $714,250 $784,963 $797,211 54.37% 67 Labor $298,500 $294,555 $292,515 $330,772 10.77% 7_Benehts $45,259 $48,551 $48,255 $57,547 24.59% )iulillllss $58,500 $51,425 $58,047 $57,721 15.75% rims-i principle Repayments , , , , n/e 11 Insurance $35,000 $55,000 $100,000 $115,000 223.57% 11 PropertyTaxes $7,550 $3,505 $3,505 $9,072 20.00% gsewiceslaccounung,trash,cleaning, etc.) $20,000 $21,000 $25,000 529,000 45.00% 130m SEA, advertising, pmmustions $5,300 $13,500 $27,200 335,350 420.00% 11 toulcosis $957,729 $1,227,287 $1,344,495 $1,441,733 50.54% liamingselorelmerest,Incomelaxes.BrDepreciationlEBlID] $335,271 $449,333 $291,254 $178,277 778.68% lllntsrssl unloan - - - - n/a IllncomeTexes $234,155 $125,953 $21,551 $49,913 773.53% linepreciatmn on values , , , , n/a 11EarningsAlla!Interesldntomexes,bepmciallon $502,115 $323,820 $209,703 $122,359 -73.53% g Mealssold 312,000.00 279,520.00 251,720.00 249,240.00 r2012% AAverage MealValue 5.75 5.00 5.25 5.50 22 23 21 25 21 27 25 23 33 31 g 31 31 33 33 31 3i v