Reference no: EM131011395
Fury’s Furniture Factory actual sales and purchases for April and May are shown here along with forecasted sales and purchases for June through September.
Sales Purchases
April (Acutal) $860,000 $350,000
May (Acutal) $840,000 $340,000
June(forecast) $815,000 $340,000
July (forecast) $815,000 $400,000
August (forecast)$830,000 $420,000
Sept (forecast) $880,000 $420,000
The company makes 22% of its sales for cash and 78% on credit. Of the credit sales, 45% are collected in the month after the sale and 55% are collected two months later. Fury’s Furniture Factory pays for 18 % of its purchases in the month after purchase and 82% two months after. Labor expense equals 16% of the current month’s sales. Overhead expense equals $24,000 per month. Interest payments of $62,500 are due in June and September. A cash dividend of $102,500 is scheduled to be paid in June. Tax payments of $55,500 are due to be paid in June and September. There is a scheduled capital outlay of $1,275,000 in September. Fury’s Furniture Factory ending cash balance in May is $42,500 and there are no marketable securities at the end of May. The minimum desired cash balance is $20,000 and the maximum desired cash balance is $75,000. Excess cash at month end (any amount above $75,000) is used to buy marketable securities. Marketable securities are sold before borrowing funds in case of a cash shortfall (cash falling below $20,000). (For this problem, the value of Marketable securities is constant. That is, there is no interest earned.)
Prepare a Cash Receipts Schedule, a Cash Payments Schedule and a Cash Budget for Fury’s Furniture Factory for June through September. Use the tables in the text as a template for completing this problem.
|
Loan by making a special payment
: Allysha just borrowed 46,300 dollars. She plans to repay this loan by making a special payment of 5,800 dollars in 5 years and by making regular annual payments of 7,900 dollars per year until the loan is paid off. If the interest rate on the loan is..
|
|
Cost of capital for the building
: A building is expected to generate no cash flows for several years and then generate annual cash flows forever. What is the value of the building if the first annual cash flow is expected in 7 years from today, the first annual cash flow is expected ..
|
|
Compute the ending inventory under fifo lifo and weighted
: Egypt Co. uses a periodic inventory system. 88 units were sold. The following are the Beginning Inventory and Purchases made during the year. Compute the ending inventory under FIFO, LIFO and Weighted Average methods.
|
|
What is the present value of the annual cash flow
: An investment, which is worth 31,000 dollars and has an expected return of 5.07 percent, is expected to pay fixed annual cash flows for a given amount of time. The first annual cash flow is expected in 1 year from today and the last annual cash flow ..
|
|
Prepare cash receipts schedule-cash payments schedule
: Fury’s Furniture Factory actual sales and purchases for April and May are shown here along with forecasted sales and purchases for June through September. The company makes 22% of its sales for cash and 78% on credit. Of the credit sales, 45% are col..
|
|
Proportion of cash flow value depends on terminal value
: A project’s annual (operating) cash flows for the next five years are $1.2 million, $1.4 million, $1.7 million, $2 million, and $2.5 million. Assuming a discount rate of 15% and a terminal growth rate of 4%, answer the following questions. a. What is..
|
|
Net working capital even further inventory financing scheme
: Currently, a firm has $30 million in cash, $20 million in accounts receivable, $45 million worth of inventory, and $10 million in taxes payable. If the firm decided to go with a just-in-time inventory process that reduced the current inventory to $5 ..
|
|
Building is expected to generate no cash flows
: A building is expected to generate no cash flows for several years and then generate annual cash flows forever. What is the value of the building if the first annual cash flow is expected in 6 years from today, the first annual cash flow is expected ..
|