Petlassa is a company with a large distribution network and selling automobile tires. The company's finance manager will meet with the General Manager to discuss the financial information for the next 3 months. USD sales amount for the past month and for the next 3 months Sales forecasts are given below: Last Month: May 250,000 Predictions: June 100,000 July 150,000 August 250,000 September 100,000 the company collects 40% of its sales in cash, 60% as 1 month term. . - Purchases make up 60% of sales. One month before Petlassa's sales making the relevant purchase; but the payment is made 1 month after the purchase date. realizes. - labor costs are 5% of sales and are paid in the relevant month. - General Management expenses amount to 15% of the sales and are paid in the relevant month.

Excel Applications for Accounting Principles
4th Edition
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Gaylord N. Smith
Chapter22: Master Budget (master)
Section: Chapter Questions
Problem 1R: Ranger Industries has provided the following information at June 30: Other information: Average...
icon
Related questions
Question

Petlassa is a company with a large distribution network and selling automobile tires.
The company's finance manager will meet with the General Manager to discuss the financial information for the next 3 months. USD sales amount for the past month and for the next 3 months
Sales forecasts are given below:
Last Month:
May 250,000
Predictions:
June 100,000
July 150,000
August 250,000
September 100,000
the company collects 40% of its sales in cash, 60% as 1 month term.
.
- Purchases make up 60% of sales. One month before Petlassa's sales
making the relevant purchase; but the payment is made 1 month after the purchase date.
realizes.
- labor costs are 5% of sales and are paid in the relevant month.
- General Management expenses amount to 15% of the sales and are paid in the relevant month.
- 10,000 USD income tax will be paid in August.
- 50,000 USD dividend payment will be made in June.
- The cash balance on June 1 is 80,000 USD and the cash balance is at the end of each month
It is required to be 60,000 USD.
All transactions take place at the end of the month. Discount rate as of today (June 1)
It was determined as 14%. What is the value of the company's cash flows?

Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Income Statement Analysis
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Corporate Fin Focused Approach
Corporate Fin Focused Approach
Finance
ISBN:
9781285660516
Author:
EHRHARDT
Publisher:
Cengage
Intermediate Financial Management (MindTap Course…
Intermediate Financial Management (MindTap Course…
Finance
ISBN:
9781337395083
Author:
Eugene F. Brigham, Phillip R. Daves
Publisher:
Cengage Learning
Principles of Accounting Volume 2
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College