When Bob is made redundant, he decides to run a business selling e-bikes. In order. to...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
When Bob is made redundant, he decides to run a business selling e-bikes. In order. to do this, he sets up a limited company, Envirobike Limited. He plans to deposit £1,000 in the company's bank account on 1 January 2022 and issue 1,000 shares, with a nominal value of £1 each, in his own name. He also plans to lend the company £20,000 using his redundancy payment. Bob will rent premises for his business at £2,300 a month. He will pay £10,000 for tools and equipment. At the start, he will pay £9,000 for bicycles and components for resale. At the end of the first month, he will pay £4,500 for more bicycles and components. At the end of the second month, he will pay £5,000 for bicycles and components. At the end of the third month he hopes to buy £5,500 of bicycles and components on credit, paying the following month At the outset, he will hire an assistant, at a cost of £2,200 a month, to work in the shop, whilst he does some work in the shop and all the administration. He will pay himself £1,200 a month in salary and plans to take further income as dividends. He estimates that he will use £160 worth of electricity per month, paid quarterly in arrears. At the beginning of lanuary he will pay £ 1,440 for 12 months' insurance. Other expenses paid for during the period will be: £ per month 260 Advertising Mileage 220 He expects his first three months' sales to be as follows: January February March 8,500 9,500 11,000 N1086 Introduction to Accounting At the end of 3 months he expects to have unsold inventory, which would had cost him £10,000. He will depreciate non-current assets at a rate of 20% of original cost per year. Envirobike Ltd Cash budget for January-March 2022 Jan Feb Mar Total £ Cash in Shares 1,000 20,000 8,500 1,000 20,000 11,000 29,000 Loan Sales 9,500 Total 29,500 9,500 11,000 50,000 Cash out Rent 2,300 10,000 13,500 2,200 1,200 2,300 2,300 6,900 10,000 18,500 6,600 3,600 Tools Goods for resale 5,000 Assistant 2,200 2,200 1,200 Bob's salary Electricity 1,200 Insurance 1,440 1,440 Advertising Mileage 260 260 260 780 220 220 220 660 Total 31,120 11,180 6,180 48,480 Net cash in (1,620) (1,680) 1,520 Opening balance Closing balance 4,820 0 (1,620) (3,300) 1,520 (1,620) (3,300) PART 2 Envirobike Ltd Budget Income Statement for the 3 months to 31 March 2022 £ Sales Revenue 29,000 (14,000) 15,000 less Cost of Sales (Note 1) Gross Profit less Operating expenses: Rent Assistant's 6,900 salary Bob's salary Electricity 6,600 3,600 480 Insurance 360 Advertising Mileage Depreciation 780 660 500 19,880 Operating profit (4,880) Note 1 Opening inventory Purchases Closing inventory Cost of Sales 24,000 (10,000) 14,000 Envirobike Ltd Budget Statement of Financial Position as at 31 March 2022 ASSETS Non-Current Assets Tools and equipment (Note 2) 9,500 Current Assets Inventory Prepaid expense (Note 3) 10,000 1,080 1,520 Cash at Bank 12,600 Total Assets 22,100 EQUITY AND LIABILITIES Equity Share capital Retained profit 1,000 (4,880) (3,880) Non-Current Liabilities Loan 20,000 Current Liabilities Trade payables Accrued expense 5,500 480 5,980 Total equity and liabilities 22,100 Note 2 Tools and equipment Cost 10,000 Depreciation Carrying amount at 31 March 2021 (500) 9,500 Note3 Insurance paid Insurance for period Prepaid expense c/f 1,440 (360) 1,080 Envirobike Ltd Budget Statement of Cashflows for the 3 months to 31 March 2022 Cash flows from operating activities Sales 29,000 (6,900) (18,500) (6,600) (3,600) (1,440) (780) (660) Rent Goods for resale Assistant Bob's salary Insurance Advertising Mileage Net Cash used in Operating Activities (9,480) Cash flows from investing activities Tools and equipment Net cash used in investing activities (10,000) (10,000) Cash flows from financing activities Issue shares 1,000 20,000 Loan Net cash used in financing activities 21,000 Net increase in cash and cash equivalents Cash and cash equivalents at 1/01/2022 Cash and cash equivalents at 31/3/22 1,520 1,520 The following ratios have been calculated from the financial statements for the 3 months to 31 March 2022. Acid test 0.43 Gross profit margin Gearing 52% (Industry average is 45%) 90% END OF PAPER QUESTION 2. Assuming a cost of capital of 1% per month, the present value of the operating cash flows for the first 3 months will be: a) £ (9,480) b) £ (9,464) c) £11,328 d) £11,520 SECTION B (QUESTIONS 3-6) In this section you do not need to explain your answer, but you must clearly show the letter of the response that is the answer that you have chosen. These questions are mainly based on Part 2 of the case study Each question in Section B is worth [10 marks] QUESTION 3. Looking at the Income Statement, which one of the following is true. a) The loss should only be £4,400 because the electricity has not actually been paid for b) Doubling sales would increase operating profit by £4,880 Sales of 10% below target would increase the loss to £6,380 d) Gross profit should be £5,000 c) When Bob is made redundant, he decides to run a business selling e-bikes. In order. to do this, he sets up a limited company, Envirobike Limited. He plans to deposit £1,000 in the company's bank account on 1 January 2022 and issue 1,000 shares, with a nominal value of £1 each, in his own name. He also plans to lend the company £20,000 using his redundancy payment. Bob will rent premises for his business at £2,300 a month. He will pay £10,000 for tools and equipment. At the start, he will pay £9,000 for bicycles and components for resale. At the end of the first month, he will pay £4,500 for more bicycles and components. At the end of the second month, he will pay £5,000 for bicycles and components. At the end of the third month he hopes to buy £5,500 of bicycles and components on credit, paying the following month At the outset, he will hire an assistant, at a cost of £2,200 a month, to work in the shop, whilst he does some work in the shop and all the administration. He will pay himself £1,200 a month in salary and plans to take further income as dividends. He estimates that he will use £160 worth of electricity per month, paid quarterly in arrears. At the beginning of lanuary he will pay £ 1,440 for 12 months' insurance. Other expenses paid for during the period will be: £ per month 260 Advertising Mileage 220 He expects his first three months' sales to be as follows: January February March 8,500 9,500 11,000 N1086 Introduction to Accounting At the end of 3 months he expects to have unsold inventory, which would had cost him £10,000. He will depreciate non-current assets at a rate of 20% of original cost per year. Envirobike Ltd Cash budget for January-March 2022 Jan Feb Mar Total £ Cash in Shares 1,000 20,000 8,500 1,000 20,000 11,000 29,000 Loan Sales 9,500 Total 29,500 9,500 11,000 50,000 Cash out Rent 2,300 10,000 13,500 2,200 1,200 2,300 2,300 6,900 10,000 18,500 6,600 3,600 Tools Goods for resale 5,000 Assistant 2,200 2,200 1,200 Bob's salary Electricity 1,200 Insurance 1,440 1,440 Advertising Mileage 260 260 260 780 220 220 220 660 Total 31,120 11,180 6,180 48,480 Net cash in (1,620) (1,680) 1,520 Opening balance Closing balance 4,820 0 (1,620) (3,300) 1,520 (1,620) (3,300) PART 2 Envirobike Ltd Budget Income Statement for the 3 months to 31 March 2022 £ Sales Revenue 29,000 (14,000) 15,000 less Cost of Sales (Note 1) Gross Profit less Operating expenses: Rent Assistant's 6,900 salary Bob's salary Electricity 6,600 3,600 480 Insurance 360 Advertising Mileage Depreciation 780 660 500 19,880 Operating profit (4,880) Note 1 Opening inventory Purchases Closing inventory Cost of Sales 24,000 (10,000) 14,000 Envirobike Ltd Budget Statement of Financial Position as at 31 March 2022 ASSETS Non-Current Assets Tools and equipment (Note 2) 9,500 Current Assets Inventory Prepaid expense (Note 3) 10,000 1,080 1,520 Cash at Bank 12,600 Total Assets 22,100 EQUITY AND LIABILITIES Equity Share capital Retained profit 1,000 (4,880) (3,880) Non-Current Liabilities Loan 20,000 Current Liabilities Trade payables Accrued expense 5,500 480 5,980 Total equity and liabilities 22,100 Note 2 Tools and equipment Cost 10,000 Depreciation Carrying amount at 31 March 2021 (500) 9,500 Note3 Insurance paid Insurance for period Prepaid expense c/f 1,440 (360) 1,080 Envirobike Ltd Budget Statement of Cashflows for the 3 months to 31 March 2022 Cash flows from operating activities Sales 29,000 (6,900) (18,500) (6,600) (3,600) (1,440) (780) (660) Rent Goods for resale Assistant Bob's salary Insurance Advertising Mileage Net Cash used in Operating Activities (9,480) Cash flows from investing activities Tools and equipment Net cash used in investing activities (10,000) (10,000) Cash flows from financing activities Issue shares 1,000 20,000 Loan Net cash used in financing activities 21,000 Net increase in cash and cash equivalents Cash and cash equivalents at 1/01/2022 Cash and cash equivalents at 31/3/22 1,520 1,520 The following ratios have been calculated from the financial statements for the 3 months to 31 March 2022. Acid test 0.43 Gross profit margin Gearing 52% (Industry average is 45%) 90% END OF PAPER QUESTION 2. Assuming a cost of capital of 1% per month, the present value of the operating cash flows for the first 3 months will be: a) £ (9,480) b) £ (9,464) c) £11,328 d) £11,520 SECTION B (QUESTIONS 3-6) In this section you do not need to explain your answer, but you must clearly show the letter of the response that is the answer that you have chosen. These questions are mainly based on Part 2 of the case study Each question in Section B is worth [10 marks] QUESTION 3. Looking at the Income Statement, which one of the following is true. a) The loss should only be £4,400 because the electricity has not actually been paid for b) Doubling sales would increase operating profit by £4,880 Sales of 10% below target would increase the loss to £6,380 d) Gross profit should be £5,000 c)
Expert Answer:
Answer rating: 100% (QA)
2 Jan Feb Mar Net Cash 1620 1680 4820 Cash in shares ... View the full answer
Related Book For
Marketing The Core
ISBN: 978-0078028922
5th edition
Authors: Roger A. Kerin, Steven W. Hartley, William Rudelius
Posted Date:
Students also viewed these general management questions
-
A local dental practice decides to run a Groupon campaign. The campaign offered $345 worth of dental services (such as teeth whitening) for $150. For the total campaign, 265 coupons were sold. We...
-
Wisk detergent decides to run a test market to see the effect of coupons and in-store advertising on sales. The index of sales is as follows: What are your conclusions and recommendations? Weeks...
-
If you were going to run a business with a family member, how would you go about deciding on the organizational culture you want to create?
-
a. An autoregressive model is given by: Yt = 20.58 + 0.046 yt-1 + 0.01Yt-2 where Y, = sales of a product. Explain the meaning of the terms in this autoregressive model. b. Write the expressions for...
-
In recent years, the number of personal bankruptcies has grown significantly faster than the number of business or commercial bankruptcies. For example, in September 2009, personal bankruptcy filings...
-
For a company like Bank of Nova Scotia, provide two examples of transactions that you would classify as financing, investing, and operating activities.
-
In July 2017, Latrice Merritt entered a residential lease with Doran 610 Apartments, LLC. Under the terms of the lease agreement, Merritt was prohibited from installing a private security system in...
-
Welch Company, which expects to start operations on January 1, 2011, will sell digital cameras in shopping malls. Welch has budgeted sales as indicated in the following table. The company expects a...
-
Does the monopoly power wielded by professional sports leagues hurt the fans, players, citizens, local economies, or the sport? What solutions could be used ?
-
A regional supplier of jet fuel is interested in forecasting its sales. These sales data are shown for the period from 2002Q1 to 2017Q4 (data in billions of gallons): Jet Fuel Sales (Billions of...
-
A relation is defined on Z by (x1, x2) (y1, y2) if and only if x1 + y2 = x2 + y. For each of the following questions, be sure to provide a proof supporting your answer. a) Is reflexive? b) Is...
-
4. Consider the following functions, where I and J denote two subsets of the set R of real numbers. f: R R x 1/x f(): IJ x f(x) (a) What is the domain of definition of f? (b) Let y be an element of...
-
Answer the following based on 2022 Amazon Quarter 2 with explanation: D. PROFITABILITY RATIOS 1. Gross Profit Margins Gross Profit Margin = (Net Sales - Cost of Goods Sold) 2. Operating Profit...
-
Find the Errors Each of the following declarations and program segments has errors. Locate as many as you can. 49. A) struct { int x; }; double y: B) struct Values { string name; int age; }
-
Calculate the cost of the inventory purchased for the purchasing company:Invoice price of goods is $ 8 , 0 0 0 . Purchase terms are 1 / 1 0 , n / 3 0 and the invoice is paid one week after it was...
-
a) [90 marks] Write a program that Splits a list into two halves. The function split() must modify the original list and return a pointer to the second half of the list, e.g., L=1234 must be 1 2...
-
This assignment fulfills the following course objectives: Identify, analyze, and demonstrate effective physical, vocal, and/or expressive delivery in public speaking Organize and articulate ideas by...
-
Suppose the index goes to 18 percent in year 5. What is the effective cost of the unrestricted ARM?
-
So what we did, in essence, is we said advertising should be useful to a consumer just as much as the organic search results, and we dont want people just to buy advertising and be able to show an ad...
-
The format in which information is presented is often vital. (a) If you were a harried marketing manager and queried your information system, would you rather see the results in tables or charts and...
-
What is the significance of user generated content when contrasted with social media and traditional media?
-
Consider the electrical circuit shown below where \(v_{i}(t)=\beta\), for \(t \geq 0\). Find the dynamic system response \(v_{o}(t)\). VC C ww R V;(t) R ww R3 A First-Order Electrical System Vo (t) +
-
Find the dynamic system response for the spring mass damping system shown in Figure 3.2, where \(f(t)=\beta, x(0)=0\) (i.e. there is no initial energy stored). b f(t) k Figure 3.2 A first-order...
-
Consider a first-order system with a forcing function \(f(t)\) such that input-output differential equation is given by \[\begin{equation*}\dot{y}+3 y=f(t) \text {, } \tag{3.7}\end{equation*}\] where...
Study smarter with the SolutionInn App