Reference no: EM131195380
Look at this financial statement info and let me know if it's correct. And
explain the calculations on how to arrive at the numbers to place in excel? Some of the formulas i don't understand how to put into excel.
So, explain yourself on the steps you take to do some of the problems.
The 2nd doc is the one I've been working on.
I maybe completely wrong with my answers but you can still view the original doc. Hopefully I'm not confusing anyone.Thanks
Read the following case study:
Precision Machines is preparing a financial plan for the next six months to determine the financial needs of the company. The historical analysis of the company's sales shows that the company's total sales are 30% cash sales and 70% credit sales. Further analysis of credit sales shows that the company receives 50% of the credit sales one month after the sale and the remaining 50% in the second month after the sale. This means the cash collections from sales are 30% in the first month of the sale, 35% in the second month, and 35% in the third month.
The materials purchased by the company amounts to 50% of the sales for the month. The company pays for the purchases one month after the initial purchase. The company likes to maintain a cash balance of $5,000. The cost of borrowing is 10%. The company plans to pay off the loan whenever there is a surplus and borrow when there is a deficit.
Attached are two excel files.
one is original.
Another is in working condition.
Attachment:- Fin.-excel (working).rar
Attachment:- original file.rar
|
What are some of these multiple policy objects the australia
: What are some of these multiple policy objects the Australian tax and transfer system tries to achieve? How does the system overreach and is hence overburdened currently? How do you propose to rationalise the tax and transfer system of Australia to o..
|
|
What is the opportunity cost of this choice
: If you invest in the high-tech common stock, what is the opportunity cost of this choice? Explain your reasoning.
|
|
What is the global product or service you are interested
: Create a presentation you would present at an interview to the interviewers. Describe the position you are interested in working for this organization. What is the global product or service you are interested in becoming a team player? What are your ..
|
|
Determine minimum number of ideal stages
: For this case, determine the following: Minimum number of ideal stages, Minimum reflux ratio (pinch point may occur close to xD) and Number of ideal stages for a reflux ratio of 2 times the minimum
|
|
Explain the calculations
: Explain the calculations on how to arrive at the numbers to place in excel? Some of the formulas i don't understand how to put into excel.
|
|
Legal underpinnings of business law
: The businesses are being sued for breach of contract. Create a matrix that lists each business, and compare and contrast your personal liability exposure as an owner as a result of the lawsuit.
|
|
Operations management plays in an organisation
: To apply the material covered in any ONE of the operations management topics in your own sphere of influence - Evaluate the utility and relevance of any ONE of the operations management topics to the contemporary business environment
|
|
Minimum of three performance appraisal methods
: Performance management includes activities which ensure that goals are consistently being met in an effective and efficient manner. Performance management can focus on the performance of an organization, a department, employee, or even the process..
|
|
Introducing the new soft drink is most profitable strategy
: Coca-Cola and PepsiCo are the leading competitors in the market for cola products. In 1960 Coca-Cola introduced Sprite, which today is the worldwide leader in the lemon-lime soft drink market and ranks fourth among all soft drinks worldwide. If you w..
|