The following are the total sales of Top Class Ltd for the past three months of 2021 Month April May June Total Sales R900 000 R700 000 R500 000 The budgeted sales figures for the next three months are expected as follows Month July August September Total Sales R825 000 R760 000 R920 000 Additional information
Q: Beaver Corporation is investigating the purchase of a new threading machine that costs $18,000. The…
A: Here, To Find: Net present value =?
Q: The risk-free rate is 3%, the market risk premium (MRP) is 8%, and the Beta of Lotsa Dough common…
A: Risk free rate = 3% Market risk premium = 8% Beta = 0.90
Q: Suppose you retire with $1million at age of 65. You plan to invest your retirement into a mixture…
A: Calculations are done in excel: Return on Risk fund is calculated using random x values to simulate…
Q: 4. In addition to the data given previously, assume that the machine will have a $13,755 salvage…
A: The internal rate of return is the method of finding the profitability of a project by finding out…
Q: 8. What is a payback period?
A: Payback Period: It is the period in which the initial investment cost is recovered. It can be…
Q: Compute the monthly payments on a 3-year lease for a $28,427 car if the annual rate of depreciation…
A: Lease can be defined as the agreement between lessor and lessee where lessor gives lessee the right…
Q: As connoisseurs of elegant fast food cuisine, we are interested in making a bid for the Greens-to-Go…
A: Given, 3 firms With levered beta, tax rate, and debt ratio.
Q: Find the future value of £2000 when it grows at an annually compounded rate of 5% for 10 years. An…
A: Future Value, FV=PV(1+i)n Here, PV (Present Value) = 2000 i (interest rate) = 5% = 0.05 n (number…
Q: If you deposit $13.224 annually at the end of every year in a bank account paying 8% annually. how…
A: Annual deposit (C) = $13,224 Interest rate (r) = 0.08 Number of deposits (n) = 5 Future value or…
Q: A new CNC machine is purchased for $40,000. The salvage value of the CNC machine is expected to be…
A: Modified accelerated rate of depreciation(MACRS) is the rate of depreciation used for determining…
Q: You purchase an RV by making a down payment of $10,700. The terms of your finance agreement have an…
A: Down payment (DP) = $10,700 Interest rate = 2.56% Monthly interest rate (r) = 2.56%/12 =…
Q: Consider the following cash flows. The interest rate is 10%. What is the duration (hint: you need…
A: Duration measures the sensitivity of an asset's price to changes in interest rates. Duration can be…
Q: An individual wishes to purchase a house that is selling for $200,000. The person has $50,000 they…
A: Value of house = $200000 Down payment = $50000 Term for amortization "n" = 10 years or 10*12 = 120…
Q: What is the expected risk-free rate of return if asset X, with a beta of 1.5, has an expected return…
A: The risk free rate of return can be calculated with the help of CAPM equation
Q: . Ji-Hoon wants to get a $500,000 3% 30-year mortgage in order to buy his first home. How much…
A: Loan amount (PV) = $500,000 Interest rate = 3% Monthly interest rate (r) = 3%/12 = 0.25% Period = 30…
Q: Given the following information, determine which beta coefficient for stock A is consistent with…
A: Expected return (rs) = 10.1% Risk free rate (rRF) = 3.2% Market return (rM) = 11.2%
Q: Paranto company has the following Capital structure: 50% equity, 30% debt; and 20% preferred stock.…
A: Weighted average cost of capital(WACC) is the average cost of capital calculated by multiplying the…
Q: 9. For the three-part question that follows, provide your answer to each part in the given…
A: Cost of Car is $18,000 Down Payment is $1,000 Monthly payments are $375 Total number of periods are…
Q: $11,000 is to be paid at the end of each year in a legal settlement. The payments end after 9 years.…
A:
Q: You would like to purchase a car that costs $47000 at 7% APR for 3 years. What is your monthly…
A: Cost (PV) = $47000 Interest rate = 7% Monthly interest rate (r) = 7%/12 = 0.583333333333333% Period…
Q: How would someone calculate the yield to maturity of a bond? How about for a three month treasury…
A: Yield to maturity can be defined as the total return on bond held by an investor till the date of…
Q: Computing EPS: Convertible Preferred Stock Charter Company earned net income of $48,000 in 2020. The…
A: Earnings per share is a method to evaluate the profitability of a company. It is one of the investor…
Q: Suppose that the general inflation rate is 5% and the real interest rate is 3%. Find the market…
A: Inflation can be defined as the increase in general price levels in the market. Inflation reduces…
Q: A) What is the formula for calculating Beta for a portfolio with three mutual funds?
A: “Since you have asked multiple questions, we will solve the first question for you. If you want any…
Q: 2. MalikCo is currently an all-equity firm with expected EBIT of Rs. 240,000 in perpetuity. The…
A: As you have asked a multiple part questions, we will answer the first three subparts for you. To get…
Q: The expected value, standard deviation of returns, and coefficient of variation for asset A are…
A: To Find: Expected return Standard deviation COV
Q: The Parkview Hospital is considering the purchase of a new autoclave. This equipment will cost…
A: Depreciation: A depreciation is a non-cash expenses for the company. The depreciation expenses is…
Q: A project requires a current expenditure of $350 and expects to generate $100 cash inflows at the…
A: We need to examine the NPV profile and decide whether to accept the project and under what…
Q: What is the NPV at a discount rate of 12.4 percent
A: Initial cash outflow = $40,500 Cash inflows Year 1 = $16,450Year 2 = $17,800Year 3 = $16842 Discount…
Q: Complete the information below using Ordinary Simple Annuity. R= P4,120 An = Sn = t = m = 12 i =…
A: Ordinary annuity is regular payments towards an investment or towards loan repayment or any other…
Q: The price of a condominium is $88,000. The bank requires a 5% down payment and one point at the time…
A: Price of Condominium is $88,000 Down payment is 5% Time period is 30 years or 30×12 = 360 months…
Q: If sterilization exists, then this implies that:
A: Sterilization is the process by which the inflow and outflow of money are controlled by the Central…
Q: Scooter wishes to sell a bond that has a face value of $1,075. The bond bears an interest rate of…
A: Face value = $1075 Coupon rate = 9.85% Interest payment = Quarterly Yield rate = 11.12%
Q: You have borrowed $40,000 to buy a new car and have an 8%, 48 month loan. How much interest will you…
A: A loan amortization schedule can be defined as a table showing the periodic repayment of principal,…
Q: 24. Financial institutions that cut back on their lending are engaged in A) liability management B)…
A: Given, (Answer 24) Meaning of Deleveraging, Whenever a person or an organization focusses to lower…
Q: Woland National Bank purchases a three-year interest rate cap for a fee of 2 percent of notional…
A: LIBOR refers to the London Interbank Offered Rate. It is the interest rate at which the banks lend…
Q: MAD for method A is 5, MAD for method B is 7, MAD for method C is 4, and MAD for method D is 2.…
A: MAD mean absolute deviation tells that how much is deviation of data from mean of the data and so it…
Q: Find the amount of each payment to be made into a sinking fund earning 7% compounded monthly to…
A: Future value (FV) = $39,000 Interest rate = 7% Monthly interest rate (r) = 7%/12 =…
Q: List five types of key investment decisions a financial manager needs to make.
A: Financial management is the part of a business dealing with bookkeeping, selecting sources of…
Q: The following information is available on two mutually exclusive projects. Project…
A: Crossover rate is the rate at which the NPV of the two projects are equal. NPV is the sum of present…
Q: How much will $10,000 grow to in 3 years, assuming an interest rate of 9% compounded quarterly? What…
A: As you have asked a multiple subpart question, we will answer the first three subparts for you. To…
Q: 7a. A large profitable corporation is considering a capital investment of $50,000. The equipment has…
A: Cash flow of a project means that what amount will flow in and out of the business by undertaking a…
Q: If the cost of capital is 18 percent and an investment costs $51,000, should you make this…
A: Cost of capital is 18% Initial cost is $51,000 Cash flow years 1-3 is $8,000 Cash flow Year 4-6 is…
Q: Not use excel Q)You take out a home loan for $250,000, with an annual interest rate of 6% for 30…
A: Solution:- When a loan is taken, it is to be repaid as a lump sum payment or in installments. When…
Q: How long would it take money to triple if it is invested at 6% compounded semi-annually
A: Future Value refers to the value of the current asset or investment or of cash flows at a specified…
Q: Would you accept a project where you had an initial investment of $10,000,000 but the NPV was only…
A: Solution:- Net Present Value (NPV) means the net value in today’s term after deducting present value…
Q: The difference between the forward rate and the expected future spot rate is called:
A: The forward rate is a price at which the transaction or settlement will take place in the future. It…
Q: Suppose you take out a 30-year mortgage for a house that costs $303,023. Assume the following: The…
A: A mortgage is a loan taken that has to be repaid in equal periodic installments. The monthly amount…
Q: 7d. A large profitable corporation is considering à capital InVe two-year project period. The annual…
A: The after-tax cash flow is the residual income of the company. To calculate the after-tax cash flow…
Q: why each should invest for college students, young college graduates in their 20s, couples with…
A: College students can take the benefit of compounding as they have enough time to grow their money.…
The following are the total sales of Top Class Ltd for the past three months of 2021
Month April May June
Total Sales R900 000 R700 000 R500 000
The budgeted sales figures for the next three months are expected as follows
Month July August September
Total Sales R825 000 R760 000 R920 000
Additional information
1) 40% of all sales are made in cash.
2) Credit sales for October 2021 are expected to be R450 000.
3) Debtors are collected as follows.
• 15% of outstanding amounts are collected during the month following the month of sale
(i.e.: 30 days). A discount of 4,5% is offered for early settlement of accounts.
• 60% is collected in the subsequent month (i.e.: 60 days).
• 20% is collected in the subsequent month (i.e.: 90 days).
• The balance is irrecoverable and needs to be written off.
REQUIRED:
Prepare a schedule of
to 31 October 2021.
Show all workings
Round to the nearest Rand
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 2 images
- Coral Seas Jewelry Company makes and sells costume jewelry. For the coming year, Coral Seas expects sales of 15.9 million and cost of goods sold of 8.75 million. Advertising is a key part of Coral Seas business strategy, and total marketing expense for the year is budgeted at 2.8 million. Total administrative expenses are expected to be 675,000. Coral Seas has no interest expense. Income taxes are paid at the rate of 40 percent of operating income. Required: 1. Construct a budgeted income statement for Coral Seas Jewelry Company for the coming year. 2. What if Coral Seas had interest payments of 500,000 during the year? What effect would that have on operating income? On income before taxes? On net income?The sales department of Macro Manufacturing Co. has forecast sales for its single product to be 20,000 units for June, with three-quarters of the sales expected in the East region and one-fourth in the West region. The budgeted selling price is 25 per unit. The desired ending inventory on June 30 is 2,000 units, and the expected beginning inventory on June 1 is 3,000 units. Prepare the following: a. A sales budget for June. b. A production budget for June.Shalimar Company manufactures and sells industrial products. For next year, Shalimar has budgeted the follow sales: In Shalimars experience, 10 percent of sales are paid in cash. Of the sales on account, 65 percent are collected in the quarter of sale, 25 percent are collected in the quarter following the sale, and 7 percent are collected in the second quarter after the sale. The remaining 3 percent are never collected. Total sales for the third quarter of the current year are 4,900,000 and for the fourth quarter of the current year are 6,850,000. Required: 1. Calculate cash sales and credit sales expected in the last two quarters of the current year, and in each quarter of next year. 2. Construct a cash receipts budget for Shalimar Company for each quarter of the next year, showing the cash sales and the cash collections from credit sales. 3. What if the recession led Shalimars top management to assume that in the next year 10 percent of credit sales would never be collected? The expected payment percentages in the quarter of sale and the quarter after sale are assumed to be the same. How would that affect cash received in each quarter? Construct a revised cash budget using the new assumption.
- Ranger Industries has provided the following information at June 30: Other information: Average selling price, 196 Average purchase price per unit, 110 Desired ending inventory, 40% of next months unit sales Collections from customers: In month of sale20% In month after sale50% Two months after sale30% Projected cash payments: Inventory purchases are paid for in the month following acquisition. Variable cash expenses, other than inventory, are equal to 25% of each months sales and are paid in the month of sale. Fixed cash expenses are 40,000 per month and are paid in the month incurred. Depreciation on equipment is 2,000 per month. REQUIREMENT You have been asked to prepare a master budget for the upcoming quarter (July, August, and September). The components of this budget are a monthly sales budget, a monthly purchases budget, a monthly cash budget, a forecasted income statement for the quarter, and a forecasted September 30 balance sheet. The worksheet MASTER has been provided to assist you. Ranger Industries desires to maintain a minimum cash balance of 8,000 at the end of each month. If this goal cannot be met, the company borrows the exact amount needed to reach its goal. If the company has a cash balance greater than 8,000 and also has loans payable outstanding, the amount in excess of 8,000 is paid to the bank. Annual interest of 18% is paid on a monthly basis on the outstanding balance.Relevant data from the Poster Companys operating budgets are: Additional data: Capital assets were sold in January for $10,000 and $4,500 in May. Dividends of $4,500 were paid in February. The beginning cash balance was $60,359 and a required minimum cash balance is $59,000. Use this information to prepare a cash budget for the first two quarters of the yearCash budget The controller of Bridgeport Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: The company expects to sell about 10% of its merchandise for cash. Of sales on account, 70% are expected to be collected in the month following the sale and the remainder the following month (second month following sale). Depreciation, insurance, and property tax expense represent 50,000 of the estimated monthly manufacturing costs. The annual insurance premium is paid in January, and the annual property taxes are paid in December. Of the remainder of the manufacturing costs, 80% are expected to be paid in the month in which they are incurred and the balance in the following month. Current assets as of September 1 include cash of 40,000, marketable securities of 75,000, and accounts receivable of 300,000 (60,000 from July sales and 240,000 from August sales). Sales on account for July and August were 200,000 and 240,000, respectively. Current liabilities as of September 1 include 40,000 of accounts payable incurred in August for manufacturing costs. All selling and administrative expenses are paid in cash in the period they are incurred. An estimated income tax payment of 55,000 will be made in October. Bridgeports regular quarterly dividend of 25,000 is expected to be declared in October and paid in November. Management desires to maintain a minimum cash balance of 50,000. Instructions Prepare a monthly cash budget and supporting schedules for September, October, and November. On the basis of the cash budget prepared in part (1), what recommendation should be made to the controller?
- Carmichael Corporation is in the process of preparing next years budget. The pro forma income statement for the current year is as follows: Required: 1. What is the break-even sales revenue (rounded to the nearest dollar) for Carmichael Corporation for the current year? 2. For the coming year, the management of Carmichael Corporation anticipates an 8 percent increase in variable costs and a 60,000 increase in fixed expenses. What is the break-even point in dollars for next year? (CMA adapted)CASH BUDGETING Helen Bowers, owner of Helens Fashion Designs, is planning to request a line of credit from her bank. She has estimated the following sales forecasts for the firm for parts of 2019 and 2020: Estimates regarding payments obtained from the credit department are as follows: collected within the month of sale, 10%; collected the month following the sale, 75%; collected the second month following the sale, 15%. Payments for labor and raw materials are made the month after these services were provided. Here are the estimated costs of labor plus raw materials: General and administrative salaries are approximately 27,000 a month. Lease payments under long-term leases are 9,000 a month. Depreciation charges are 36,000 a month. Miscellaneous expenses are 2,700 a month. Income tax payments of 63,000 are due in September and December. A progress payment of 180,000 on a new design studio must be paid in October. Cash on hand on July 1 will be 132,000, and a minimum cash balance of 90,000 should be maintained throughout the cash budget period. a. Prepare a monthly cash budget for the last 6 months of 2019. b. Prepare monthly estimates of the required financing or excess fundsthat is, the amount of money Bowers will need to borrow or will have available to invest. c. Now suppose receipts from sales come in uniformly during the month (that is, cash receipts come in at the rate of 1/30 each day), but all outflows must be paid on the 5th. Will this affect the cash budget? That is, will the cash budget you prepared be valid under these assumptions? If not, what could be done to make a valid estimate of the peak financing requirements? No calculations are required, although if you prefer, you can use calculations to illustrate the effects. d. Bowers sales are seasonal, and her company produces on a seasonal basis, just ahead of sales. Without making any calculations, discuss how the companys current and debt ratios would vary during the year if all financial requirements were met with short-term bank loans. Could changes in these ratios affect the firms ability to obtain bank credit? Explain.A companys controller is adjusting next years budget to reflect the impact of an expected 3 percent inflation rate. Listed below are selected items from next years budget before the adjustment. After adjusting for the 3 percent inflation rate, what is the companys total budget for the selected items before taxes for next year? a. 858,150 b. 860,412 c. 810,971 d. 858,971
- Eastman, Inc., manufactures and sells three products: R, S, and T. In January, Eastman, Inc., budgeted sales of the following. At the end of the year, actual sales revenue for Product R and Product S was 3,075,000 and 3,254,000, respectively. The actual price charged for Product R was 25 and for Product S was 20. Only 10 was charged for Product T to encourage more consumers to buy it, and actual sales revenue equaled 540,000 for this product. Required: 1. Calculate the sales price and sales volume variances for each of the three products based on the original budget. 2. Suppose that Product T is a new product just introduced during the year. What pricing strategy is Eastman, Inc., following for this product?Cash budget The controller of Mercury Shoes Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: The company expects to sell about 10% of its merchandise for cash. Of sales on account, 60% are expected to be collected in the month following the sale and the remainder the following month (second month after sale). Depreciation, insurance, and property tax expense represent 12,000 of the estimated monthly manufacturing costs. The annual insurance premium is paid in February, and the annual property taxes are paid in November. Of the remainder of the manufacturing costs, 80% are expected to be paid in the month in which they are incurred and the balance in the following month. Current assets as of June 1 include cash of 42,000, marketable securities of 25,000, and accounts receivable of 198,000 (150,000 from May sales and 48,000 from April sales). Sales on account in April and May were 120,000 and 150,000, respectively. Current liabilities as of June 1 include 13,000 of accounts payable incurred in May for manufacturing costs. All selling and administrative expenses are paid in cash in the period they are incurred. An estimated income tax payment of 24,000 will be made in July. Mercury Shoes regular quarterly dividend of 15,000 is expected to be declared in July and paid in August. Management desires to maintain a minimum cash balance of 40,000. Instructions Prepare a monthly cash budget and supporting schedules for June, July, and August. On the basis of the cash budget prepared in part (1), what recommendation should be made to the controller?The data shown were obtained from the financial records of Italian Exports, Inc., for March: Sales are expected to increase each month by 10%. Prepare a budgeted income statement.
