Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Laura Smith owns a brand name clothing store. The business has been doing well and making good profit. Following is the balance sheet of the

Laura Smith owns a brand name clothing store. The business has been doing well and making good profit. Following is the balance sheet of the store on 31 December 2014.

Lauras Clothing Store

Balance Sheet

31 December 2014

Cash

$8,750

Shop equipment (net)

22400

Inventory

33,250

Accounts receivable

10,500

Total Assets

$74,900

Accounts payable

$15,750

Owners equity, capital

59,150

Total Liabilities and Owner's Equity

$74,900

On 2 January 2015 Laura went to her bank to get a loan for her business. The bank agreed to loan her $17,500 under the following conditions. First, the note payable would be a three-year note, so the business would repay $17,500 plus $5,250 interest on 31 December 2017. Second, she must prepare a forecasted classified income statement for 2015 to show that the business expects to earn a net income of at least $38,500 and that it will have satisfactory profit margin and return ratios. Third, she must prepare a forecasted cash flow statement for 2015 that shows the business expects to have cash on hand at the end of 2015 of at least $35,000 (including the cash from the bank loan) and that it will have satisfactory operating cash flow ratios. Finally, she must prepare a forecasted classified balance sheet as of 31 December 2015, that shows a current ratio of at least 3.0 and debt ratio of no more than 40%. Laura has never prepared any forecasted financial statements. She understands, however, that they are prepared using the best estimates she can make, based on the shops previous operations and her future expectations.

Laura has come to you for help with the following information.

(a) Sales for 2015 are expected to be $280,000. Of these, half will be cash sales and half credit

sales. There are no cash discounts. Of the credit sales, 10% will not be collected until 2016. The accounts receivable on 31 December 2014 will be collected in 2015.

(b) Purchases of inventory for 2015 are expected to be $175,000. All purchases are on credit; there are no cash discounts. Of the purchases, 12% will not be paid until 2016. The accounts payable on 31 December 2014 will be paid in 2015.

(c) Sales returns and purchases returns are expected to be insignificant.

(d) The businesss gross profit percentage has been 40% of sales, and this rate is expected in 2015.

(e) The shop rents space in a local shopping center. The rent is $700 per month; the rent for the whole year is due on 6 January 2015.

(f) The shop equipment that originally cost $28,000 has a 10-year estimated life, after which it is expected to have no value.

(g) Laura pays her one salesperson a basic salary of $24,500 per year, plus 10% of gross sales. The total salary for 2015 will be paid in cash by the end of the year.

(h) Laura expects to withdraw $28,000 during 2015 to cover personal living expenses.

(i) Other operating expenses are expected to be $5,600 in 2015; these will be paid in cash by the end of the year.

You determine that the information Laura has gathered is reasonable and includes her best estimates.

Required:

1-Prepare a forecasted classified income statement for 2015 and show supporting calculations.

2-Prepare a forecasted cash flow statement for 2015. Use the direct method for operating cash flows and show supporting calculations.

3-Prepare a forecasted classified balance sheet as of 31 December 2015 and show supporting calculations.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Introduction To Managerial Accounting Hc 2002 Text Only

Authors: Folk

1st Edition

0071123350, 978-0071123358

More Books

Students also viewed these Accounting questions

Question

My opinions/suggestions are valued.

Answered: 1 week ago