(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

Problem A DEF has total forecasted gross purchases of P4,500,000 relating to a major supplier for the coming year. The supplier is offering a credit term of 3/15, n/45. How much is the simple annual effective cost of paying on the 45th day? Problem B ABC can take a 45-day loan with a 15% interest deducted in advance, to be reapplied each time. How much is the simple annual cost of the loan? Problem C ABC’s bank offered a loan with conditions of a P5,000,000 face amount, 6-month term, 4% interest deducted in advance and bank charge of P30,000. How much is the compounded annual effective cost of the bank loan?
A loan of $15,000 is to be financed over a period of 24 months. The agency quotes a nominal interest rate of 6% for the first 12 months and a nominal interest rate of 9% for any remaining unpaid balance after 12 months with both rates compounded monthly. At these rates, what equal end-of-the-month payment for 24 months would be required in order to repay the loan? (Choose the closest answer)
You are responsible to manage an IS project with a 4-year horizon. The annal cost of the project is estimated at $40,000 per year, and a one-time costs of $120,000. The annual monetary benefit of the project is estimated at $96,000 per year with a discount rate of 6 percent. a. Calculate the overall return on investment (ROI) of the project. b. Perform a break-even analysis (BEA). At what year does break-even occur?
Nikul
Using the future values tables, solve the following: What is the future value on December 31, Year 11, of 20 cash flows of $15,000 with the first cash payment made on December 31, Year 1, and the annual interest rate of 10% being compounded semiannually?
You are considering an investment in a Third World bank account that pays a nominal annual rate of 18%, compounded monthly. If you invest $5,200 at the beginning of each month, how many months would it take for your account to grow to $500,000? Round fractional months up. a. 38 months b. 60 months c. 46 months d. 17 months e. 27 months
1. Suppose you are paying GHS 51.88 per week for 14 years to repay a GH¢18,000 loan.What is the annual effective interest rate. 2. Calculate the effective interest rate if the interest rate is 26% per annum compoundeddaily. 3. Calculate the total amount of money that would be accumulated if an amount ofmoney of GH¢ 6,000 is invested quarterly for 15 years at an interest rate of 22% peryear compounded quarterly
A company is due to receive €2,500,000 two-months from today and wishes to save the funds for three months. Money market interest rate spreads for short-term euro transactions are presented in the table below. Money Market Euro Interest Rate Spreads (%) 1 month 2 months 3 months 4 months 5 months 6 months 0.20 - 0.25 0.28– 0.33 0.35 – 0.40 0.45 – 0.56 0.60 – 0.67 0.75 – 0.83 A bank is willing to offer the company a forward rate agreement (FRA), incorporating a forward rate fixed at the level calculated in part a). When the money is received, the €LIBOR rate is 0.35%. Calculate and explain the terms on which the FRA is settled.
A company caps three-month LIBOR at 10% per annum. The principal amount is S20 million. On a reset date three-month LIBOR is 12% per annum. What payment would this lead to under the cap? When would the payment be made?
Revenues generated by a new fad product are forecast as follows: Year Revenues $45,000 1 2 35,000 3 25,000 4 20,000 Thereafter 0 Expenses are expected to be 40% of revenues, and working capital required in each year is expected to be 20% of revenues in the following year. The product requires an immediate investment of $60,000 in plant and equipment.
Please step by step solltion
Carmen's Beauty Salon has estimated monthly financing requirements for the next six months as follows: $ 9,100 April January February 3,100 May March 4,100 June $9,100 10,100 5,100 Short-term financing will be utilized for the next six months. Projected annual interest rates are: January 5% April 12% 6% May 12% February March 9% June 12% What long-term interest rate would represent a break-even point between using short-term financing and long-term financing? Note: Round your monthly interest rate to 2 decimal places when expressed as a percent. Round your interest payments to the nearest whole cent. Input your answer as a percent rounded to 2 decimal places. Interest rate