Solution-What is the final cash balance by june

What is the final cash balance by june

Assignment Help Finance Basics

Reference no: EM132886109

Prepare a cash forecast considering the following:

Direct sales paid 30 days
Sales to distributors 50% cash, 25% after 30 days, 25% after 60 days.
Local suppliers paid 60 days, import suppliers paid 30 days.
Personnel cost (Direct personnel cost + Indirect personnel cost +Sales department + Administration) and taxes, are paid at the end of the month.
Commissions from sales agent (5%) are paid after receiving full amount from the customers (Direct customers and distributors).
Starting cash January 1st is 5.000€
At the end of December, the company has a loan of 20.000€. The company pays interest every month, based on an annual interest of 6%, (0.5% per month), calculated in base of the loan balance of the previous month.
Their credit facility has a maximum amount of 300.000€
The company wants to hold a minimum cash balance of 20.000€
Prepare a cash planning.
The company issued Bonds 5 years ago, and they have to pay 500.000€ by June 30th.

Question 1: Will they be able to pay in time?

Question 2: What is the final cash balance by June 30th.?

Reference no: EM132886109

Questions Cloud

Calculate the prices of the bonds : Calculate the prices of the bonds if the required return falls to 7%. Could you explain why the price increases or decreases given change in required return

Loss of confidence in the chipotle brand : What Factors Contributed to the Loss of Confidence in the Chipotle Brand?

Explained how apple contract with book publishers : The opening story explained how Apple's contract with book publishers gave them a unified front to approach Amazon to demand higher prices

What was the growth rate of total assets : Takoradi Tools had total assets of $20,900 at the end of 2016, $21,800 at the end of 2017, What was the growth rate of total assets

What is the final cash balance by june : Will they be able to pay in time? What is the final cash balance by June 30th.? Sales to distributors 50% cash, 25% after 30 days, 25% after 60 days.

List the benefits of group interviews : List the benefits of Group Interviews.

Deliberate practice makes perfect : Ricardo is an associate financial analyst in a large financial consulting firm. He works in the emerging markets division developing low-cost products for the S

Chooses a publicly traded firm listed on nyse or nasdaq : Chooses a publicly traded firm listed on NYSE or NASDAQ, pretending a financial analyst. Students provide detailed financial analysis for a potential customers

What is the weighted average coupon : Consider the following pool of mortgages: What is the Weighted Average Coupon (WAC) for this pool at origination

User Account

All Pages

What is the final cash balance by june

Reference no: EM132886109

Reference no: EM132886109

Questions Cloud

Reviews

Write a Review

Finance Basics Questions & Answers

Financial reporting and analysis

A report on financial accounting

Describe the types of financial ratios

Differences between sole proprietorship and corporation

Prepare a cash budget statement

What are the implied interest rates

State pricing theory and no-arbitrage pricing theory

Small business administration

Effect of financial leverage

Evaluate the basis for the payment to the lender

Importance of opps, ipps, mpfs and dmepos

Time value of money

Assured A++ Grade

Academics

Major Subjects

Majors

Get In Touch

TERMS & POLICIES

HELP & SUPPORT