Calculating Payments Marshall plc's purchases from suppliers in a quarter are equal to75 per cent of the next quarter's forecast sales. The payables period is 60 days. Wages,taxes and other expenses are 20 per cent of sales, and interest and dividends are £60 perquarter. No capital expenditures are planned.Here are the projected quarterly sales:Sales (£)Q1750Q2920Q3Q4890790Sales for the first quarter of the following year are projected at £970. Calculate the com-pany's cash outlays by completing the following:Payment of accountsWages, taxes, other expensesLong-term financing expenses.(interest and dividends)TotalQ1Q2Q3Q4

For your convenience, I will also provide an Excel sheet. THANK YOU

Answered: Calculating Payments Marshall plc's…

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

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.)
Suppose that a company borrows $100,000 from investment pool at 14% compounded quarterly over 3 years. If the average quarterly general inflation rate is expected to be 0.35%, determine the equivalent equal quarterly payment series in constant dollars.
For the year ending December 31, 2017, sales for Corporation Y were $68.01 billion. Beginning January 1, 2018 Corporation Y plans to invest 7.5% of their sales amount each year and they expect their sales to increase by 6% each year over the next three years. Corporation Y invests into an account earning an APR of 1.4% compounded continuously. Assume a continuous income stream. How much money will be in the investment account on December 31, 2020? Round your answer to three decimal places. billion dollars How much money did Company Y invest in the account between January 1, 2018 and December 31, 2020? Round your answer to three decimal places. billion dollars How much interest did Company Y earn between January 1, 2018 and December 31, 2020? Round your answer to three decimal places. If intermediate values are used, be sure to use the unrounded values to determine the answer. billion dollars Submit Answer View Previous Question Question 10 of 10 Home My Assignments +Request Extension…
i need the answer quickly
Vijay
For the year ending December 31, 2017, sales for Company Y were $73.91 billion. Beginning January 1, 2018 Company Y plans to invest 9.5% of their sales amount each year and they expect their sales to increase by 4% each year over the next three years.Company Y invests into an account earning an APR of 2.2% compounded continuously. Assume a continuous income stream.How much money will be in the investment account on December 31, 2020?Round your answer to three decimal places. billion dollarsHow much money did Company Y invest in the account between January 1, 2018 and December 31, 2020?Round your answer to three decimal places. billion dollarsHow much interest did Company Y earn on this investment between January 1, 2018 and December 31, 2020?Round your answer to three decimal places. If intermediate values are used, be sure to use the unrounded values to determine the answer. billion dollars
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
aa.4
For the year ending December 31, 2017, sales for Corporation Y were $63.21 billion. Beginning January 1, 2018 Corporation Y plans to invest 8.5% of their sales amount each year and they expect their sales to increase by 5% each year over the next three years. Corporation Y invests into an account earning an APR of 1.4% compounded continuously. Assume a continuous income stream. How much money will be in the investment account on December 31, 2020? Round your answer to three decimal places. billion dollars How much money did Company Y invest in the account between January 1, 2018 and December 31, 2020? Round your answer to three decimal places. billion dollars How much interest did Company Y earn between January 1, 2018 and December 31, 2020? Round your answer to three decimal places. If intermediate values are used, be sure to use the unrounded values to determine the answer. billion dollars
Receivables Investment Snider Industries sells on terms of 2/10, net 25. Total sales for the year are $500,000. Thirty percent of customers pay on the 10th day and take discounts; the other 70% pay, on average, 30 days after their purchases. Assume a 365-day year. What is the days sales outstanding? Do not round intermediate calculations. Round your answer to the nearest whole number. days What is the average amount of receivables? Do not round intermediate calculations. Round your answer to the nearest dollar. $ What would happen to average receivables if Snider toughened its collection policy with the result that all nondiscount customers paid on the 25th day? Do not round intermediate calculations. Round your answer to the nearest dollar. $
For the year ending December 31, 2017, sales for Company Y were $72.11 billion. Beginning January 1, 2018 Company Y plans to invest 8.5% of their sales amount each year and they expect their sales to increase by 7% each year over the next three years. Company Y invests into an account earning an APR of 2.0% compounded continuously. Assume a continuous income stream. How much money will be in the investment account on December 31, 2020? Round your answer to three decimal places. X billion dollars How much money did Company Y invest in the account between January 1, 2018 and December 31, 2020? Round your answer to three decimal places. billion dollars How much interest did Company Y earn on this investment between January 1, 2018 and December 31, 2020? Round your answer to three decimal places. If intermediate values are used, be sure to use the unrounded values to determine the answer. billion dollars TEACHER Submit Answer

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