Prepare a cash flow summary and external financing summary

Assignment Help Operation Management

Reference no: EM132214796

Assignment

Good cash management is an essential job of the financial manager! You own a small auto sales business called King Kars. You stock up on inventory in February, April, June, and September.

Your annual cash budget indicates that your MONTHLY NET CASH for the year will be the following:

JAN $5,000

FEB -$30,000

MAR $20,000

APRIL -$35,000

MAY $25,000

JUNE -$10,000

JULY $25,000

AUG $25,000

SEPT -$30,000

OCT $15,000

NOV $15,000

DEC $25,000

You begin the year with a cash balance of $50,000, and the minimum cash balance desired must be $50,000 every month. Prepare a cash flow summary and external financing summary as noted in the Excel spreadsheet assigned to this submission.

1. Do you believe that the company needs outside financing?

2. What is the minimum line of credit to request from a lender?

3. Do you think you are a good candidate for the line of credit? Why?

Please submit the Excel template below, saved under your name, with the columns and rows completed with the cash flows. Also in this template, you must include the answers to questions 2 and 3 in the assignment.

Reference no: EM132214796

Questions Cloud

Impacts of the ever-changing it industry : create a two-minute video and written proposal about the impact of a particular technology on an industry or field - explore various impacts

Specifically engages the issue of normativism : Note: While similar to the other question with the same illustration, this question specifically engages the issue of normativism.

Design atotal compensation plan for an imaginary competitor : Design a 100-word total compensation plan (written in the third person voice) for an imaginary competitor of Amazon, Home Depot, Starbucks, FedEx Corporation.

Created an innovation dynamo : How 3M Gave Everyone Days Off and Created an Innovation Dynamo. Explain and assess how these functions assist 3M in their HR planning and resourcing,

Prepare a cash flow summary and external financing summary : Good cash management is an essential job of the financial manager! You own a small auto sales business called King Kars.

Examine a community scenario for ethical considerations : For this Discussion, you examine a community scenario for particular ethical considerations that would be most important to consider for the case.

Transparency of their plans for potential investors : Give your analysis of Alibaba's m-commerce strategy and the transparency of their plans for potential investors.

Provide an opportunity to utilize your skills and knowledge : MGT201 : Provide an opportunity to utilize your skills and knowledge to research cultural differencesbetween countries.

Determine appropriate type of financing assess risk : Determine total dollar amount needed to start your business Determine appropriate type of financing Assess risk, feasibility, and personal investment

User Account

All Pages