You currently have a cash balance of $140,000, receivables of $220,000 and paybables of $90,000. Average days inreceivables is 30 and average days in payables is 42. You typically order 50% of next quarters predicted sales in rawmaterials which is your variable cost. Salaries and other related costs typically amount to 20% of your current periodsales. Last years sales were as detailed below by quarter. You expect an increase of 5% year on year on last years salesQ1Q2Q3Q4400,000410,000430,000400,000

To proceed with the analysis based on the provided data, let's break down the requirements and…

Answered: You currently have a cash balance of…

Essentials Of Investments

11th Edition

ISBN:9781260013924

Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Chapter1: Investments: Background And Issues

Section: Chapter Questions

Problem 1PS

See similar textbooks

Similar questions

Ratchet Ltd expects to sell 30,000 units this year. The selling price is set at $25 per unit. The variable cost per unit is $12 and annual fixed cost is $345,000. Assume a tax rate of 28%. Required: Calculate the following: Break-even point in dollars. Margin of safety in dollars. Number of units Ratchet Ltd has to sell to earn an after-tax profit of $420,000.
Last year, Flynn Company reported a profit of $70,000 when sales totaled $520,000 and the contribution margin ratio was 40%. If fixed expenses increase by $10,000 next year, what amount of sales will be necessary in order for the company to earn a profit of $80,000?
Please make in excel and take screenshots. A Pumpkin Pie Manufacturing Company pays on the tenth day after purchase. The average collection period is 35 days, and the average inventory age is based on inventory turnover of 9 times per year. The company spends about $16 million on operating cycle investments, and is considering a plan that would lengthen its average payable period by 20 days. If the company pays 12% per year on its investment of resources, what annual savings-if any-can it realize with this plan? Assume there is no discount for early payment of accounts payable and a year has 360 days.
Kelly and Sam Morse have invested $500,000 in K&S Place. Their projected costs and activities are as follows: Variable Cost Monthly Fixed Costs Monthly Covers Served 63% $30,000 10,000 Answer the following questions below. Show your work. 1. If a monthly profit of $5000 must be earned in addition to the fixed costs, what must the average check be? 2. What would you want to compare the result you calculated with so see if it is reasonable to achieve that check?
Nombre Company management predicts $390,000 of variable costs, $430,000 of fixed costs, and a pretax income of $155,000 in the next period. Management also predicts that the contribution margin per unit will be $9. Use this information to compute the (1) total expected dollar sales for next period and (2) number of units expected to be sold next period.
Lewellen Products has projected the following sales for the coming year: 01 02 03 04 Sales $940 $1,020 $980 $1,080 Sales in the year following this one are projected to be 20 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. What is the payables period in this case? (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.) a. b. Payment of accounts Payment of accounts Payment of accounts 01 02 Q3 Q4
Please make in excel and take screenshots. A Pumpkin Pie Manufacturing Company pays on the tenth day after purchase. The average collection period is 35 days, and the average inventory age is based on inventory turnover of 9 times per year. The company spends about $16 million on operating cycle investments, and is considering a plan that would lengthen its average payable period by 20 days. If the company pays 12% per year on its investment of resources, what annual savings-if any-can it realize with this plan? Assume there is no discount for early payment of accounts payable and a year has 360 days. exercise in the image, it is in Spanish, but it is the original one. exercise in the image, it is in Spanish, but it is the original one I already translated it for you, the other image is the format... I can't translate the format, but it's easy to deduce.
A 50-room hotel has an ADR of $140 per room, variable cost of $25 per room and monthly fixed costs of $100,000. The average occupancy rate is equal to 60%. What is total monthly revenue equal to at the break-even point?
An inventory item has a demand of 10,000 units per month. The cost of each unit is $6, and the interest on tied-up money is 10%. The average ordering cost is $250 per order. a) What is the EOQ? units (round your response to the nearest integer). b) What is the optimal number of orders per year? to the nearest integer) c) What is the optimal number of days between any two orders? your response to the nearest integer) d) What is the annual holding cost? $ nearest integer) orders (round your response e) What is the total annual cost of the inventory system? $ to the nearest integer) days (round per year (round your response to the (round your response
Robert's Repair Shop has a monthly target profit of $19,500. Variable costs are 75% of sales, and monthly fixed costs are $13,000. Requirements 1. Compute the monthly margin of safety in dollars if the shop achieves its income goal. 2. Express Robert's margin of safety as a percentage of target sales. 3. Why would Robert's management want to know the shop's margin of safety? ... Requirement 1. Compute the monthly margin of safety in dollars if the shop achieves its income goal. Select the labels and enter the amounts to compute Robert's Repair Shop's monthly margin of safety in dollars. Target sales in dollars Breakeven sales in dollars Margin of safety in dollars
= Adam's Repair Shop has a monthly target operating income of $12,500. Variable expenses are 75% of sales, and monthly fixed expenses are $9,500. Hint: The contribution margin ratio= 100% - Variable expenses percentage of sales. Read the requirements. Requirement 1. Compute the monthly margin of safety in dollars if the shop achieves its income goal. Begin by identifying the formula to compute the margin of safety. = Margin of safety in dollars (Round intermediate calculations up to the nearest whole dollar and your final answer to the nearest whole dollar.) The margin of safety is Requirement 2. Express Adam's margin of safety as a percentage of target sales. Begin by identifying the formula to compute the margin of safety as a percentage of target sales. (Round the percentage to the nearest whole percent.) The margin of safety percentage is % of target sales. Requirement 3. What is Adam's operating leverage factor at the target level of operating income? Begin by identifying the…
2 You currently have a cash balance of $140,000, receivables of $220,000 and payables of $90,000. Average days in receivables is 30 and average days in payables is 42. You typically order 50% of next quarter's predicted sales in raw materials which is your variable cost. Salaries and other related costs typically amount to 20% of your current period sales. Last year's sales were as detailed below by quarter. You expect an increase of 5% year on year on last year's sales. Q1 400,000 02 410,000 Q3 430,000 Create a cashflow prediction by quarter for the next four quarters. Q4 400,000

SEE MORE QUESTIONS

Recommended textbooks for you

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS