Question: What is your expected net clas flow in Q1, Q2, Q3, Q4? Please provide excel worksheet with and without formulas. cash * Intro It is

What is your expected net clas flow in Q1, Q2, Q3, Q4? Please provide excel worksheet with and without formulas.

cash *

Intro It is the beginning of January. Actual sales for the previous quarter (Q4) and estimated sales for the next five quarters are as follows (in $ million): Quarter Q4 Q1 Q2 Q3 Q4 Q1 Sales 28 29.4 30.87 32.41 34.03 35.74 You collect 10% of sales in the current quarter and the remainder in the following quarter. You expect to spend 40% of the following quarter's sales on purchases of components from suppliers, and to pay 60% of those purchases in the current quarter and the remainder in the following quarter. Wages and other expenses add up to 30% of each quarter's sales. You have to pay $4 million in interest and dividends each quarter, and plan to spend $7 million on new machinery in Q3. Assume that each quarter has 90 days, sales occur evenly throughout the quarter and all other cash flows occur at the end of the quarter

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

BUS105: Master Budgeting Case Instructions: Read the case below and complete the Master Budget Template in Excel. When you open the Master Budget Template, notice the first tab, Facts. When working...

Questions 6-9, please show formulas. From this year's accounting records, Ana expects first quarter beginning inventory to consist of 600 units. She knows that the sales manager wants to end cach...

1. what is your expected total cash collection in future Q4? 2. what is your expected total cash disbursement in future Q4? 3. what is your expected cash balance at the end of Q4? Please provide...

Please show the formulas. Unique Sinks Master Budget Unique Sinks is a family-owned manufacturing business specializing in sinks; it does not produce any of the faucets or plumbing needed for...

Hello, I need the attached work completed by Saturday morning. 1 2 3 4 Walter Fields Week 5 Unit Cost under Variable Costing Direct Materials Direct labor Variable Manufacturing OH Variable Selling &...

Please provide excel worksheets with and without formulas. I will not be able to compelte this problem without them. if provided a thumbs up will be given. Problem 9 Intro It is the beginning of...

I can get about halfway through this problem but I'm stuck. Please help if you can! help if you can! AutoSave OFF A B 2.C ? - Home Insert Draw Page Layout Formulas Data Review View Conditional...

Using the link attach create a master budget. This assignment is to be submitted using an Excel XLS or XLSX workbook. Each budget schedule is to be contained on a separate spreadsheet tab. You are to...

Hi Vjvgoe, Are you able to help me with this problem please? I would need to see it 7/16/17 since it's due that same week but I will put the deadline on 7/29/17. I have attached all of the...

Problem 26 >>> Intro It is the beginning of January. Actual sales for the previous quarter (Q4) and estimated sales for the next five quarters are as follows (in $ million): Quarter Q4 Q1 Q2 Q3 Q4 Q1...

Express common base parameters in terms of common-emitter parameters.

What are the advantages and disadvantages of a letter of intent?

At a Christmas party, Julie tells her best friend, Mandy, that her boyfriend, Ralph, had confessed to her that he had sexually assaulted his two nieces on Halloween. Julie is subsequently killed in a...

A company is preparing completing their Cash Budget. The following data has been prepared for cash receipts and payments. January February March Cash receipts $1,061,200 $1,182,400 $1,091,700 Cash...