Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Your family business is expanding. Based on your experience and in depth knowledge of the market, you have estimated the following results for the first

Your family business is expanding. Based on your experience and in depth knowledge of the market, you have estimated the following results for the first 2 years (8 quarters) of the project. Expected revenues for the first two years are as follows. o In addition, sales for the 1st quarter of Year 3 are projected at $370,000. Year 1 ('000s) Year 2 ('000s) Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 10 20 40 70 110 160 220 290 General and administrative expenses (wages, taxes, office etc.) are estimated to be 15% of sales. Sales salaries and commissions are estimated to be 12% of sales. Accounts receivable at the beginning of this expansion are $0. o Collection period = 30 days Accounts payable at the beginning of the expansion are $0. o The Company quarterly purchases from suppliers = 40% of the next quarter's forecasted sales. o Suppliers are paid on average in 45 days. You will need to buy new equipment & furniture in both Year 1 - Q1 and Q3 for $25,000 ($50,000 total in Year 1). To help start the expansion you have secured an initial cash loan from the bank of $50,000. Interest on this loan is $1,500 per quarter. The company will pay back the full $50,000 in the Year 2 - Q4. Interest on any additional short-term borrowing is expected to be 2% per quarter. The company required return must be at least this each quarter. The Company wishes to maintain a $50,000 minimum balance at all times to best manage its working capital and any unexpected commitments

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

Step: 3

blur-text-image

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

Horngrens Financial And Managerial Accounting

Authors: Tracie Miller Nobles, Brenda Mattison, Ella Mae Matsumura

6th Edition

0134486838, 978-0134486833

Students also viewed these Accounting questions

Question

List the four factors involved in a SWOT analysis.

Answered: 1 week ago

Question

10. What is meant by a feed rate?

Answered: 1 week ago

Question

Technology

Answered: 1 week ago

Question

Population

Answered: 1 week ago

Question

The feeling of boredom.

Answered: 1 week ago