You have developed a chain of 10 cyber cafes near university campuses like Wits, UCT, UJ,...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
You have developed a chain of 10 cyber cafes near university campuses like Wits, UCT, UJ, Rhodes and Stellenbosch. Your business concept is to serve Java to the budding revolutionaries, the caviar communists and limousine liberals that live in these vanguards of social change. Smoking is of course prohibited indoors, but outside your cafes the gentle sweetness of clove cigarettes and patchouli scents the air. Marxist slogans are incorporated into the names of chic, soy-based, mocha drinks. Computer terminals allow young manifesto writers to find and comment upon the latest conspiracy theories. Gluten-free brownies are served. All coffees are fair-trade, their flavors untainted by globalism, that hideous scourge so often hoisted on the backs of the innocents by greedy, money-grubbing, warmongering agents of that hegemonic evil, corporate America. In spite of the fact that money is the root of all evil, you are highly profitable. You have decided to expand your operations by opening new cafes. You plan to add another 3 cafes each year for the next 4 years so that there will be 22 cafes in all. You lease the space for each cafe for R180,000 per year and you spend R800,000 to build each cafe to your specifications. Construction for 2018 is on schedule and you will have 13 cafes fully operational by the end of the fiscal year. When a café opens, the R800,000 expenditure is depreciated at 10% per year straight line for book purposes. In addition, each cafe has 20 days of inventories on hand and can get 30 days credit terms from its suppliers. You estimate that every cafe you open adds R300,000 per year to your SG&A expense. It takes 12 mouths to build out each cafe during which you incur lease expenses (and the additional SG&A expenses) but earn no revenue at that site. You expect that, once a cafe opens its doors, revenues flow at an annual rate of R1,000,000 per café with a gross margin of 75%. You maintain a cash balance of 4% of sales for working capital purposes. Accounts receivable and accounts payable are immaterial. The income tax rate is 28%. You have a line of credit at a bank that allows you to borrow up to R10 million at an interest rate of 15%. You paid a special dividend on Dec 31, 2017, but the bank will not allow you to pay dividends if your line of credit is drawn down. Questions: Draw up a set of proforma financial statements (income statement, balance sheet and cash flow statement) for each of the years 2018 through 2022. 1. How large was the dividend you paid on 31 Dec. 2017? 2. Estimate the amount of financing you will need to meet your expansion plans assuming all your projections are accurate. Assumptions: 1. It takes 12 months to build each cafe and it produces no revenues during the year it is constructed, although rental (R180,000 per cafe) and incremental SG&A (R300,000 per cafe) start when construction starts. 2. Depreciation does not start until the cafe produces revenues. 3. For simplicity, assume that interest charge in year t is based on the balance of the bank loan at the end year f-1. (1.e., if the bank loan for 2016 is R100. then the interest payment in 2017 is R15.) This exercise is designed to familiarise you with the mechanics of financial analysis. After you have built the pro-formas, please do the following: 1. Assume a growth rate of 3% and a discount rate of 25% (Don't worry about where these numbers come from) and calculate the NPV of the revolutionary endeavor. 2. AVC offers you R1 million for a 20% equity stake in your company, discuss the merits of this offer. The most recent balance sheet and income statements are: Balance sheet Share capital Retained earnings Loans Total capital Fixed Assets Cost (original) Acc dep Current assets Debtors Inventory Cash Current Liabilities Creditors Overdraft NCA Net Assets Dec 2016 5,000,000 2,330,000 7,330,000 7,200,000 8,000,000 800,000 430,000 150,000 200,000 80,000 300,000 300,000 50,000 7,330,000 Dec 2017 5,000,000 1,521,096 6,521,096 6,400,000 8,000,000 1,600,000 326,575 109,589 136,986 80,000 205,479 205.479 41,096 6.521.096 Income statement Sales COS GP SG&A Rentals Depreciation PBIT Interest PBT Tax PAT 2017 10,000,000 2,500,000 7,500,000 3,000,000 1,800,000 800,000 1,900,000 1,900,000 532,000 1,368,000 You have developed a chain of 10 cyber cafes near university campuses like Wits, UCT, UJ, Rhodes and Stellenbosch. Your business concept is to serve Java to the budding revolutionaries, the caviar communists and limousine liberals that live in these vanguards of social change. Smoking is of course prohibited indoors, but outside your cafes the gentle sweetness of clove cigarettes and patchouli scents the air. Marxist slogans are incorporated into the names of chic, soy-based, mocha drinks. Computer terminals allow young manifesto writers to find and comment upon the latest conspiracy theories. Gluten-free brownies are served. All coffees are fair-trade, their flavors untainted by globalism, that hideous scourge so often hoisted on the backs of the innocents by greedy, money-grubbing, warmongering agents of that hegemonic evil, corporate America. In spite of the fact that money is the root of all evil, you are highly profitable. You have decided to expand your operations by opening new cafes. You plan to add another 3 cafes each year for the next 4 years so that there will be 22 cafes in all. You lease the space for each cafe for R180,000 per year and you spend R800,000 to build each cafe to your specifications. Construction for 2018 is on schedule and you will have 13 cafes fully operational by the end of the fiscal year. When a café opens, the R800,000 expenditure is depreciated at 10% per year straight line for book purposes. In addition, each cafe has 20 days of inventories on hand and can get 30 days credit terms from its suppliers. You estimate that every cafe you open adds R300,000 per year to your SG&A expense. It takes 12 mouths to build out each cafe during which you incur lease expenses (and the additional SG&A expenses) but earn no revenue at that site. You expect that, once a cafe opens its doors, revenues flow at an annual rate of R1,000,000 per café with a gross margin of 75%. You maintain a cash balance of 4% of sales for working capital purposes. Accounts receivable and accounts payable are immaterial. The income tax rate is 28%. You have a line of credit at a bank that allows you to borrow up to R10 million at an interest rate of 15%. You paid a special dividend on Dec 31, 2017, but the bank will not allow you to pay dividends if your line of credit is drawn down. Questions: Draw up a set of proforma financial statements (income statement, balance sheet and cash flow statement) for each of the years 2018 through 2022. 1. How large was the dividend you paid on 31 Dec. 2017? 2. Estimate the amount of financing you will need to meet your expansion plans assuming all your projections are accurate. Assumptions: 1. It takes 12 months to build each cafe and it produces no revenues during the year it is constructed, although rental (R180,000 per cafe) and incremental SG&A (R300,000 per cafe) start when construction starts. 2. Depreciation does not start until the cafe produces revenues. 3. For simplicity, assume that interest charge in year t is based on the balance of the bank loan at the end year f-1. (1.e., if the bank loan for 2016 is R100. then the interest payment in 2017 is R15.) This exercise is designed to familiarise you with the mechanics of financial analysis. After you have built the pro-formas, please do the following: 1. Assume a growth rate of 3% and a discount rate of 25% (Don't worry about where these numbers come from) and calculate the NPV of the revolutionary endeavor. 2. AVC offers you R1 million for a 20% equity stake in your company, discuss the merits of this offer. The most recent balance sheet and income statements are: Balance sheet Share capital Retained earnings Loans Total capital Fixed Assets Cost (original) Acc dep Current assets Debtors Inventory Cash Current Liabilities Creditors Overdraft NCA Net Assets Dec 2016 5,000,000 2,330,000 7,330,000 7,200,000 8,000,000 800,000 430,000 150,000 200,000 80,000 300,000 300,000 50,000 7,330,000 Dec 2017 5,000,000 1,521,096 6,521,096 6,400,000 8,000,000 1,600,000 326,575 109,589 136,986 80,000 205,479 205.479 41,096 6.521.096 Income statement Sales COS GP SG&A Rentals Depreciation PBIT Interest PBT Tax PAT 2017 10,000,000 2,500,000 7,500,000 3,000,000 1,800,000 800,000 1,900,000 1,900,000 532,000 1,368,000
Expert Answer:
Answer rating: 100% (QA)
Proforma Financial Statements 20182022 Income Statement Year Revenue COGS Gross Profit SGA Depreciation EBIT Interest Tax Net Income 2018 10000000 750... View the full answer
Related Book For
Auditing and Assurance Services Understanding the Integrated Audit
ISBN: 978-0471726340
1st edition
Authors: Karen L. Hooks
Posted Date:
Students also viewed these accounting questions
-
Your doctor tells you that you have developed a urinary tract infection by the Gramnegative bacterium E coli and prescribes the antibiotic nitrofurantoin However, you had some antibiotics leftover...
-
You have developed a new hair growth drug that is expected to revolutionize the hair growth industry. Your product launch is expected to cost $1.9M, have a four-year life, and have a salvage value of...
-
You have developed a set of criteria for evaluating distressed credits. Companies that do not receive a passing score are classed as likely to go bankrupt within 12 months. You gathered the following...
-
Describe the relationship of the AD, SRAS, and LRAS curves when the economy is in long-run macroeconomic equilibrium.
-
Sara Anderson says that she is a busy woman with no time to look at favorable variances. Instead, she concentrates solely on the unfavorable ones. She says that favorable variances imply that...
-
Discuss any experiences you have had with a site-specific safety program (SSSP). If you worked on a site and had to attend their orientation, was it specific or general to the site? If you have had...
-
When admitting a new partner, how is the new partner's equity calculated?
-
Beckett Industries manufactures a popular interactive stuffed animal for children that requires two computer chips inside each toy. The company pays $ 3 for each computer chip. To help to guard...
-
Why does Tygiel assert that Comiskey, Mack, Griffith, and McGraw "epitomized the promise of the nation" as a group? Why does Tygiel assert that Comiskey, Mack, Griffith, and McGraw "epitomized the...
-
Sun Valley Rides is a wholesaler of motorcycle supplies. An aging of the companys accounts receivable on December 31, 20Y3, and a historical analysis of the percentage of uncollectible accounts in...
-
QUESTION 34 Consider a bond with a 8% semiannual coupon bond, 15 years to maturity, and a par value of $1,000. The current price is $ 1200. What is the yield to maturity? 5.96% 6.25% O 4.74% O 6.29%
-
Your company has a 1 million Euro receivable in one year. You decided to fully hedge with forward contracts. The one year forward rate is 1 . 2 2 USD / EUR . How much will you receive in USD in one...
-
Pick three of the Consumer Trends identified by Euromonitor International and provide (for each of the three) a commentary on the type based on secondary research on the internet and your own...
-
What is the difference between the following: int abc; int *xyz; Is one more vulnerable than the other? How is system call different from exec (or its variants).
-
a. Which monopoly charges a greater price markup? b. Which monopoly has greater monopoly power?
-
A market research firm is hired to estimate the percent of consumers living in a large city who would recommend the Brand A. Five hundred randomly selected consumers in this city are surveyed to...
-
John, White male, 46, heterosexual, married to his wife Jane of 10 years, got referred to you for a drug and alcohol assessment because he wrecked his car while drunk and high on THC. In order to...
-
What is the difference between adsorption and absorption?
-
Philly Communications is the largest provider of telephone and cable service in Pennsylvania. During its yearend audit, the manager at Dell & Wayne, Philly's independent audit firm determined that...
-
Explain the importance of a walkthrough, how one is performed, and list 5 relevant questions that the auditor might ask during a walkthrough. What types of responses to your questions might the...
-
What might influence an audit firms decision about whether it wants a company as a client?
-
Which is bigger: \(100^{10000}\) or \(10000^{100}\) ? Which is bigger: the cube root of 3 or the square root of 2 ? (No calculators allowed!)
-
Find an integer \(n\) and a rational \(t\) such that \(n^{t}=2^{1 / 2} 3^{1 / 3}\).
-
When we want to add three numbers, say \(a+b+c\), we don't bother inserting parentheses because \((a+b)+c=a+(b+c)\). But with powers, this is not true \(-\left(a^{b} ight)^{c}\) need not be equal to...
Study smarter with the SolutionInn App