{"id":35248,"date":"2018-02-20T23:50:30","date_gmt":"2018-02-20T23:50:30","guid":{"rendered":"https:\/\/writemyessayfree.com\/prepare-a-cash-flow-forecast-for-the-appropriate-period"},"modified":"2017-08-16T06:31:24","modified_gmt":"2017-08-16T06:31:24","slug":"prepare-a-cash-flow-forecast-for-the-appropriate-period","status":"publish","type":"post","link":"https:\/\/www.benedictsol.com\/blogs\/prepare-a-cash-flow-forecast-for-the-appropriate-period\/","title":{"rendered":"Prepare a cash flow forecast for the appropriate period"},"content":{"rendered":"
\n

Lisa and Mark, the third generation of the Gilbert family, had successfully taken the family business from one small caf? in Appleton to a profitable multi-site restaurant business. Realizing in the late \u201970s that healthy eating was a trend with staying power, they had changed both the name and nature of \u201cGilbert\u2019s\u201d, their grandfather\u2019s corner caf?, transforming it into \u201cButterflies\u201d, a restaurant specializing in light and healthy food.<\/p>\n

Butterflies had grown from strength to strength. The first location was such a success that Lisa and Mark were encouraged to open a second\u2026 and then a third\u2026 until today they had five such restaurants within a 30 miles radius of Appleton. People love the fine food and the beautiful surroundings, and customers came from a wide area to experience the delights of Butterflies.<\/p>\n

The twins were discussing their potential sixth restaurant.<\/p>\n

Lisa: Well I think that the Oakley site would be a great place for the new Butterflies. It\u2019s a really good location, the right size buildings, loads of parking space, and best of all we already own it outright. What\u2019s your problem?<\/p>\n

Mark: No problem with any of that. I\u2019m just concerned that we might be missing something. Sure, we know that we can make money if we open a Butterflies, but perhaps we should look at the alternatives- we could always just sell the property and do something else with the money. lets face it- we should be able to get at least 300,000 pounds for it if we put it on the market tomorrow.<\/p>\n

Lisa: Yes, but I\u2019d much rather set up a new Butterflies there. We get a lot of customers from out Oakley way- this is a chance to capitalize on their goodwill. Remember that market research work I commissioned about this in February?<\/p>\n

Mark: I should think so- it cost us 3,000 pounds.<\/p>\n

Lisa: Money well spent though. It showed that there is definite potential for a Butterflies out at Oakley- lots of our customers thought it was a good idea, and lots of new people too.<\/p>\n

Mark: Okay then- lets look at the figures. What are we talking about?<\/p>\n

Lisa: Well I reckon that a restaurant that size should take about 500,000 pounds a year; although in the first year we\u2019d probably only do 75% of that due to the start up. But with out basic cost of food running at only about 40% of sales, that gives us a gross profit of some 300,000 a year- and I reckon that about 90% of that would be customers who aren\u2019t eating at the other Butterflies restaurants already, so that\u2019s got to be worth going for!<\/p>\n

Mark: Yes, but we\u2019d have to knock overheads off that. What are we looking at there? Chefs, waiters, kitchen staff, heat and light, rates, cleaning, laundry, those fresh flowers you insist we always have\u2026 have you got any numbers?<\/p>\n

Lisa: Of course ive got numbers! I reckon that wed have fixed costs of about 160,000 pounds a year, plus depreciation of 15,000 pounds. That includes the cost of a manager to run it. I think we should persuade Mike Barnett to do that.<\/p>\n

Mark: Mike Barnett? Isn\u2019t he due to retire this year?<\/p>\n

Lisa: Yes, in june, just when we plan to open Oakley. But im sure he\u2019d stay on abit longer, and we could just bring in this replacement a couple of months early to enable him to leave the Allerton site in April to work at the new location. I reckon we could persuade him to defer his retirement bonus for one more year and set up Oakley for us. And he\u2019d do it for 18,000 pounds a year \u2013 which is the same, as we\u2019d have to pay any other manager, but Mike\u2019s experience would make it much easier. Then at the end of his extra year we pay him his 1,000 pounds retirement bonus\u2026<\/p>\n

Mark:Pehaps you\u2019d better make that 1,500 if he\u2019d going us such a favour.<\/p>\n

Lisa: \u2026 Okay, 1,5-pounds, and then we bring in someone new. Still at 18,000 pounds though. How am I doing do far?<\/p>\n

Mark: Fine. Now tell me how much we\u2019ll have to spend on setting it up.<\/p>\n

Lisa: Well, probably about 100,000 pounds for decoration and equipment.<\/p>\n

Mark: Ouch!<\/p>\n

Lisa: Yes, but don\u2019t panic- that includes 20,000 pounds for the cost of kitchen equipment transferred out of the Childwall site. Remember we need to get some better stuff for there because business has grown so quickly? I figured that rather than sell it off for a tiny amount\u2026<\/p>\n

Mark: we\u2019d probably get 5,000 pounds for it !<\/p>\n

Lisa: don\u2019t interrupt! Yes, rather than sell it off like we did last time, why not use the old equipment in the new restaurant? It\u2019s perfectly serviceable. And it cost us 20,000 pound last year, so why not use it ?<\/p>\n

Mark: Great idea. I suppose that we can also use the Oakley site to help cover our central overheads: our offices, your salary and mine, accountants\u2019 fees, and all that stuff. What does that work out to\u2026 we\u2019d charge it about 15,000 pounds a year I suppose?<\/p>\n

Lisa: Yes, it must cover its fair share of the costs, so that sounds reasonable. And there\u2019s a couple of other points we\u2019d need to consider- financing all of the basic inventories- all that \u201cworking capital\u201d stuff that dad used to keep on about. What shall we say- inventories run at about 5% of sales?<\/p>\n

Mark: Sounds about right to me. Lets run the numbers.<\/p>\n

Required:<\/p>\n

Please \u201crun the numbers\u201d for Mark and Lisa:<\/p>\n

1. Prepare a cash flow forecast for the appropriate period. Assume that the restaurant will be run for six years, at the end of which the building could be sold for 300,000 pounds but the equipment will have no value at all. Also assume that tax will be calculated at 30% of profits ignoring depreciation, and that there are no tax allowances available on any of the equipment. Tax is paid in the year after the profit is made.<\/p>\n

2. Note that Mark and Lisa require a return of at least 14%. Should they go ahead with the Oakley expansion?<\/p>\n<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

Lisa and Mark, the third generation of the Gilbert family, had successfully taken the family business from one small caf? in Appleton to a profitable multi-site restaurant business. Realizing in the late \u201970s that healthy eating was a trend with Read More …<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-35248","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/35248","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/comments?post=35248"}],"version-history":[{"count":0,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/35248\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/media?parent=35248"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/categories?post=35248"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/tags?post=35248"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}