(a)next quarter. The following forecast sales for the year of 2021:Sakura Group has been engaged in the process of forecasting its financing needs over theMonthMaySalesRM775,000JuneJulyAugustSeptemberOctoberRM970,000RM880,000RM1,375,000RM1,633,000RM1,890,000The company's sales of 40 percent is collected in the month of sales and the remaining balance willbe collected in the following months after sales.Sakura's purchase raw material equal to 82 percent of sales and its makes purchases a month inadvance of sales. 60 percent of purchases are cash, and 35 percent is paid in the following monthand the remaining is never collected.Additional information:(1i) Interest income of RM10,500 on marketable securities will be received in August.(ii) Other income of RM1,650 will receive every end of quarter.(iii) The firm paid worker wages based on 5 percent of sales in the month.(iv) The utilities is expected at 2 percent of sales in the month of the sales.(v) Monthly rental expenses is RM33,030.(vi) The cost of new asset is RM225,500 and pay in cash in July. This new asset will depreciateRM1,550 per month. (vii) The company will pay tax of RM55,090 in August and property tax of RM65,800 in September.(viii) Equipment expenses are RM75,080 are paid equally twice per year on February and August.(ix) A dividend of RM49,380 will be paid at the beginning of each quarter.(x) Beginning cash balance for the budget period is RM10,000 with a minimum cash balance ofRM50,000 and increase to RM155,000 in August and RM309,700 in September onwards.(xi) Interest on accumulated loan is at 15 percent annual interest and is paid in the following month.Prepare a monthly cash budget of quarter 3 in 2021 for Sakura Group.

The cash budget is prepared by forecasting the cash collections and cash payments. Any excess or…

(a) next quarter. The following forecast sales for the year of 2021: Sakura Group has been engaged in the process of forecasting its financing needs over the Month Sales May June July August September October RM775,000 RM970,000 RM880,000 RM1,375,000 RM1,633,000 RM1,890,000 The company's sales of 40 percent is collected in the month of sales and the remaining balance will be collected in the following months after sales. Sakura's purchase raw material equal to 82 percent of sales and its makes purchases a month in advance of sales. 60 percent of purchases are cash, and 35 percent is paid in the following month and the remaining is never collected.

(a) next quarter. The following forecast sales for the year of 2021: Sakura Group has been engaged in the process of forecasting its financing needs over the Month Sales May June July August September October RM775,000 RM970,000 RM880,000 RM1,375,000 RM1,633,000 RM1,890,000 The company's sales of 40 percent is collected in the month of sales and the remaining balance will be collected in the following months after sales. Sakura's purchase raw material equal to 82 percent of sales and its makes purchases a month in advance of sales. 60 percent of purchases are cash, and 35 percent is paid in the following month and the remaining is never collected.

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Hillary's Health Food Store has estimated monthly current asset financing requirements for the next six months as follows: January February March April May June Current Assets Temporary Permanent $6,000 $4,000 $1,000 $4,000 $2,000 $4,000 $6,500 $4,000 $5,000 $4,000 $2,000 $4,000 Projected annual borrowing rates for the next six months are: January February 6.0% April 12.0% May 9.0% June 7.0% March 9.0% Short- Term Long- Term 5.0% 9.6% 9.6% 9.6% 9.6% 9.6% 9.6% Required: a. Assuming the company follows the hedging strategy, calculate the TOTAL dollar interest payments for the six months. b. If the company implemented a risky strategy would you expect total dollar interest payments to be higher or lower, briefly explain your answer (calculation not required).
Sexton Products has projected the following sales for the coming year: Q1 Q2 Q3 Q4 Sales $ 930 $ 1,010 $ 970 $ 1,070 Sales in the year following this one are projected to be 10 percent greater in each quarter. a. Calculate payments to suppliers assuming that the company places orders during each quarter equal to 30 percent of projected sales for the next quarter. Assume that the company pays immediately. (Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.) b. Calculate payments to suppliers assuming a 90-day payables period. (Do not round intermediate calculations and round your answers to 2 decimal places, e.g ., 32.16.) c. Calculate payments to suppliers assuming a 60-day payables period. (Do not round intermediate calculations and round your answers to 2 decimal places, e. g., 32.16.)
XYZ sdn bhd estimating its cash requirement for the third quarter year 2011. The company's projected sales are as follows: month sales (rm) march 170,000 april 160,000 may 140,000 june 180,000 july 200,000 august 220,000 september 195,000 october 180,000 i) cash sales are 10% of the current month's sales, while 90% of them were sold on credit. 60% of the month's credit sales are paid in the month following the sale, while 30% of it are paid in the second month following the sales. another 10% is bad debt. ii) purchases are 50% of sales and were made one month before sales. iii) payments on accounts are on 30% of current month's purchases plus 70% of the previous month's purchases. iv) wages and salaries amounting to 10% of the preceeding month's sales. v) an 8% semi-annually interest payment on rm 100,000 notes payable is to the paid in July 2011. vi) the company plans to pay rm 6,500 in cash for a brand-new computer in august. vii) a quarterly dividend of rm 10,000 will be paid to ABC…
The MacDonald Corporation’s purchases from suppliers in a quarter are equal to 60 percent of the next quarter’s forecast sales. The payables period is 60 days. Wages, taxes, and other expenses are 40 percent of sales, and interest and dividends are $124 per quarter. No capital expenditures are planned. Projected quarterly sales are: Q1 Q2 Q3 Q4 Sales $1,230 $1,380 $1,470 $1,680 Sales for the first quarter of the following year are projected at $1,350. Calculate the company’s cash outlays by completing the following: (Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.)
If ABC plans to pay 30% of the month’s purchases during the month of purchase, 50% in the next month, and the balance two months from the month of purchase, how much would the total payments to suppliers be for the month of April?
Forecasted cash receipts and expenditure for the period August to October are as follows: Cash Receipts Expenditure $ $ 60,000 58,000 July August September October 54000 68,000 90,000 30,000 44,000 Additional information provided: ✓ Expenditure for the period July to October includes monthly depreciation of $5,000. ✓ Payment for the cash related expenditure would be 40% in the month of purchase, the balance being paid the following month. The company intends to sell equipment valued at $25,000 in September. Insurance of $25,000 is payable in December. Opening cash balance as at August 1, $18,800. Required: Prepare a monthly Cash Budget for the period August to October 2021.
Assume today is 15 Jan 2020. You t e the following information regarding Salalah Ceramics 31 Dec 2019 31 Dec 2020 31 Dec 2021 31 Dec 2022 Cash Flow from 12000 Operations Cash Investment 7600 Cash flow from operations will grow by 10% every year up to 2022 and cash investment will grow by 20% every year up to 2022. FCF growth after 2022 will be 5% and required return is 12%. Assuming net debt is 7000 1. What is the firm's enterprise value 2. What is the firm's value of equity
The Bandon Pine Corporation's purchases from suppliers in a quarter are equal to 60 percent of the next quarter's forecast sales. The payables period is 60 days. Wages, taxes, and other expenses are 40 percent of sales, and interest and dividends are $114 per quarter. No capital expenditures are planned. Projected quarterly sales are: Sales Q1 $ 1,500 Q2 Q3 04 $ 1,650 $ 1,710 $ 1,950 Sales for the first quarter of the following year are projected at $1,620. Calculate the company's cash outlays by completing the following: Note: Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16. Payment of accounts Wages, taxes, other expenses Long-term financing expenses (interest and dividends) Total Q1 Q2 Q3 Check my work Q4
The Martin Company expects its total sales in the first quarter of 2024 will be $200,000 . Martin estimates that , in each subsequent quarter , total sales will increase by 10 % of the sales in the immediately preceding quarter . Martin estimates that 60 % of each quarter's sales will be on account , and 40 % will be for cash . Of the amount on account , 75% will be collected in the same quarter the sale occurred , and 25 % will be collected in the following quarter . Assume Martin will have no accounts receivable at the beginning of 2024. The balance in the Accounts Receivable account at the end of the third quarter is expected to be: $42,000 $ 30,000 $36,300 $ 60,000 $108,900
Superstar Berhad reported sales of RM70,000 in May and RM80,000 in June. The forecast sales for July, August and September are RM90,000, RM100,000, and RM110,000, respectively. The beginning cash balance on July 1 is RM3,000 and the firm wishes to maintain a minimum cash balance of RM5,000 every month. The total long-term liabilities of the company is RM25,000. Given the following data, prepare a cash budget for the months of July, August and September. The firm makes 20% of sales for cash, 60% are collected in the next month, and the remaining 20% are collected in the second month following sale. The firm receives other income of RM 2,000 per month. The firm’s actual or expected purchases, all made for cash, are RM65,000, RM70,000, and RM85,000 for the months of July through September, respectively. Rent is RM5,500 per month. Wages and salaries are 10% of the previous month’s sales. The net income is RM30,000. Cash dividends is 20% of the net income and will be paid in August. The…
Broussard Skateboard's sales are expected to increase by 20% from $8.4 million in 2019 to $10.08 million in 2020. Its assets totaled $5 million at the end of 2019. Broussard is already at full capacity, so its assets must grow at the same rate as projected sales. At the end of 2019, current liabilities were $1.4 million, consisting of $450,000 of accounts payable, $500,000 of notes payable, and $450,000 of accruals. The after-tax profit margin is forecasted to be 6%, and the forecasted payout ratio is 55%. Use the AFN equation to forecast Broussard's additional funds needed for the coming year. Enter your answer in dollars. For example, an answer of $1.2 million should be entered as $1,200,000. Do not round intermediate calculations. Round your answer to the nearest dollar. $
Data are as follows: In year 2020, sales are 150,000 units with Selling price per unit of 10 and VC per unit iof 6.50 per unit. Fixed cost is 155,000 and Interest cost is 90,000. Q3. Assume that the company expects to have sales increase by 20%, what will be the resulting change in EBIT in year 2021? • 28.38% • 26.45% • 25% • 33.33%