Managerial Finances in MS Excel

Must be able to do Managerial Finance calculations using MICROSOFT EXCEL and Briefly right up the analysis in a word doc.

Assume you have just earned your master’s degree in finance and are now employed by the Cosmo K Manufacturing Group. Your employment is contingent on your successful completion of several tasks over the next four weeks and the successful completion of a comprehensive exam to obtain company certification in finance. Each week, you will be assigned projects of interest to the company that will test your competence in finance.
Gerry has decided that you need some experience in evaluating other firms in the marketplace. Accordingly, he has asked you to select any company listed on the NYSE or the NASDAQ. For your selected company, identify and download the most recent financial statements for the last three to five years, to include the following:
•    Balance sheet
•    Income statement
•    Per share data
Tasks:
Gerry would like you to complete the following tasks and submit your report by the end of the week:
•    Identify the predominant industry in which your company operates. Find the industry averages for that industry for the following ratios:
o    Current ratio
o    Debt ratio
o    Quick ratio
o    Debt-equity ratio
o    Total asset turnover
o    Profit margin
o    Inventory turnover
o    Return on assets
o    Receivables turnover
o    Return on equity
•    Calculate as many of the listed ratios for your selected company as possible using the financial statements you acquired.
•    Conduct a trend analysis for the last three to five years. What trends can you identify? What do they indicate?
•    Compare the ratios for the last common year to the industry averages. What conclusions can you draw regarding your company’s performance? What are your company’s strengths and weaknesses?
•    Identify the changes that need to be made by the company to improve its performance, as compared to the industry, on the basis of the ratios.
•    Conduct a DuPont analysis for your selected company. What conclusions can you draw for improving your company’s performance on the basis of this analysis?

Don't use plagiarized sources. Get Your Custom Essay on
Managerial Finances in MS Excel
From as low as $9/Page
Order Essay

•    Present the numerical data and calculations in a Microsoft Excel sheet and write the analyses in a Microsoft Word document. For more information on Managerial Finances in MS Excel check out:

Attachment: Supplemental Reading_Week 1 Week 1 Knowledge Check Project 1_

The Homework Writings
Order NOW For A 10% Discount!
Pages (550 words)
Approximate price: -

Our Advantages

Plagiarism Free Papers

Thehomeworkwritings.com’s team of writers write all papers from scratch. We deliver 100% original, unique papers. That’s what makes us the best custom homework writing service

Free Revisions

We provide unlimited free revisions to all customers and on all papers. Try The Homework Writings today for the best custom homework writing service and experience in the industry.

Title-page

Thehomeworkwritings.com gives clients title pages free of charge. Your only job is to fill out our order form. We will handle the rest.

Bibliography

As the leading essay writing service, we never submit any paper without a reference/bibliography page. We do this free of charge too.

Originality & Security

At Thehomeworkwritings.com, we take great pride in delivering only high-quality 100% original papers to all our clients. We also never share any of our clients’ information with third parties. Your data is safe with us.

24/7 Customer Support

No other custom homework writing service has a friendly, always available customer support team to respond to clients like us.

Try it now!

Calculate the price of your order

We'll send you the first draft for approval by at
Total price:
$0.00

How it works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.

Why outsource our services

We have the best customer support team for your essay writing needs.

Pricing

Flexible Pricing

You won’t find any other custom homework writing service with pricing as flexible and affordable as ours.

Communication

Admission help & Client-Writer Contact

We provide a direct line of communication with our writers for the best writing experience.

Deadlines

Paper Submission

As the leading custom homework writing service, we take deadlines very seriously. You will have your paper submitted on time without any delays.

Reviews

Customer Feedback

We truly value your feedback, good or bad, and always use your feedback to help us provide you with an even better custom homework writing service