Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Hi, I asked this question before,but the answer was unhelpful and I am still stuck. I was not given instructions on how to solve this

Hi,

I asked this question before,but the answer was unhelpful and I am still stuck.

I was not given instructions on how to solve this problem. I don't know which numbers are to be used to calculate materials purchased. Is it 50 % of a combination of November and December's combined total collections? How is interest calculated? Am I to calculate 10% of capital expenditures and dividends or just enter 10%? Is there a spreadsheet guide that I can purchase that has these answers for how to complete the rest of the form? Any assistance would be appreciated.

Can someone show me how to complete the rest of the spreadsheet?

image text in transcribed Precision Machines Student Note: Fill in the light yellow cells Data: Annual Cost of borrowing Minimum Cash Balance Beginning Cash Balance Revenues (Sales) Cash Collections First Month (30%) Second Month (35%) Third Month (35%) Total Collections Cash Disbursements Material Purchases Salaries Wages Other Expenses Capital Expenditure Dividends Interest Total Disbursements Cash flows Net cash flows Cumulative cash flows Minimum Cash Balance Cash Surplus or (Deficit) Recommendations: November December January February $40,000.00 $50,000.00 $48,000.00 $55,000.00 November $12,000.00 December $15,000.00 14,000.00 $ 12,000.00 $ 29,000.00 10.00% $5,000.00 $7,500.00 January February $14,400.00 $16,500.00 17,500.00 14,400.00 14,000.00 17,500.00 $ 45,900.00 $ 48,400.00 6,000.00 3,000.00 6,000.00 3,500.00 March April May June $35,000.00 $50,000.00 $65,000.00 $40,000.00 March April May June $27,000.00 $15,000.00 $19,500.00 $12,000.00 19,250.00 27,000.00 15,000.00 22,750.00 14,400.00 19,250.00 27,000.00 15,000.00 $ 60,650.00 $ 61,250.00 $ 61,500.00 $ 49,750.00 6,000.00 3,000.00 6,000.00 3,200.00 45,000.00 1,000.00 6,000.00 3,500.00 6,000.00 3,000.00 1,000.00 4,600.00 Precision Machines Team Assignment FIN/370 Version 10 University of Phoenix Material Precision Machines Read the following case study: Precision Machines is preparing a financial plan for the next six months to determine the financial needs of the company. The historical analysis of the company's sales shows that the company's total sales are 30% cash sales and 70% credit sales. Further analysis of credit sales shows that the company receives 50% of the credit sales one month after the sale and the remaining 50% in the second month after the sale. This means the cash collections from sales are 30% in the first month of the sale, 35% in the second month, and 35% in the third month. The materials purchased by the company amounts to 50% of the sales for the month. The company pays for the purchases one month after the initial purchase. The company likes to maintain a cash balance of $5,000. The cost of borrowing is 10%. The company plans to pay off the loan whenever there is a surplus and borrow when there is a deficit. The attached spreadsheet shows revenues (sales), expenses, capital expenditures, and other expenses for Precision Machines' next six months. Using the information given on the spreadsheet, prepare a cash budget for January through June and determine the cash surplus, deficit, and the financing needs of the company. Copyright XXXX by University of Phoenix. All rights reserved. 1

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

Practical Financial Management

Authors: William R. Lasher

6th Edition

1439080496, 978-1439080498

More Books

Students also viewed these Finance questions

Question

5. How quickly can we manage to collect the information?

Answered: 1 week ago

Question

3. Tactical/strategic information.

Answered: 1 week ago

Question

3. To retrieve information from memory.

Answered: 1 week ago