Financial Analysis

Prepare an analysis of the assigned company (1500 – 2,000 words) in order to secure a loan for the company. The loan will increase the company’s total liabilities by 3%. The contents of the project include the following: Discuss the loan amount and how you plan to use the loan proceeds. Use the Excel Spreadsheet provided and complete the following. a. Prepare a five-year vertical analysis of the company’s income statement. Prepare a projected income statement for 2020 and 2021 assuming sales increase by 3% and 6%. Compute the ratios listed with the income statement. Compute the ratios listed with the balance sheet. Using the results of your spreadsheet, what questions would you ask the CFO of the company? Explain. The assigned company, spreadsheet, detailed instructions, and guidance are provided during week three. see the following and complete the attached excel sheet. Financial Analysis: Open the Excel spreadsheet provided. Prepare a vertical analysis of Bridgford’s income statement. Enter the percentages in columns C, E, G, I, and K. For additional information regarding vertical analysis, please review the following. Vertical Analysis Prepare: a projected income statement assuming sales increase by 3% in 2020 and 6% in 2021. Average your vertical analysis percentages for each income statement account and enter the results in column L, rows 5 – 11. Example: Add columns C, E, G, I and K and divide by 5. (64.07+60.58+63.17+67.57+67.34)/5=64.55%. Column L, row 5 = 64.55%. Enter your projected sales number in columns M & N, row 4. Columns M and N: Multiply projected sales by the average percentage for each income statement account. Ratio Computations. Use Excel formulas to calculate financial ratios listed with the income statement and balance sheet tabs. Calculate ratios for seven years (i.e. 2015-2021). Do not prepare ratios that require data from the 2020 and 2021 balance sheet. In this case, “N/A” is entered in the appropriate cell. For additional information regarding ratios, please review the following. Financial Ratios Note: If there is a discrepancy between the formula used in our text versus the formula included with the above link, use the formula incorporated with the above link. Loan: The written section of the project includes a loan discussion and CFO questions and explanations. Use the following resources to complete your analysis. Form 10-K Corporate Annual and Earnings Report Chief Financial Officer Questions: Using the results of your spreadsheet, what questions would you ask the CFO of Bridgford Foods? Explain. Format your paper consistent with APA guidelines. Deliverables:  Paper (MS Word) and Excel Spreadsheet. Review your Originality Report generated from SafeAssign. A new originality report is created with each attempt. Your last attempt is used for grading. 

Don't use plagiarized sources. Get Your Custom Essay on
Financial Analysis
Just from $13/Page
Order Essay
Order a unique copy of this paper
(550 words)

Approximate price: $22

Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our Guarantees

Money-Back Guarantee

Are you displeased with your final paper, even after several rectifications? Do not worry. At Assignments123, customer satisfaction is our number one priority. Though uncommon, if you are completely displeased with your final paper and do not want to take advantage of our free revisions policy, you are entitled to a refund. At Assignments123, we view our money-back guarantee as a right rather than a benefit.

We believe our clients deserve the best assignment service they can get on the internet. If you feel we did not deliver the highest quality paper possible, we have a straightforward and streamlined refund process.

Zero-Plagiarism Guarantee

At Assignments123, we have a strict anti-plagiarism policy. We take extra precaution when writing your papers, to ensure none of your work is flagged for plagiarism. Our custom assignment help experts make use of professional plagiarism checking software.

We also make use of professional paraphrasing software when writing your papers. When you hire our expert assignment help service, we will pair you with a writer who will create 100% original and plagiarism free work. Once our writers are done with your paper, our professional editors also proofread your document to ensure there are no traces of plagiarism.

Free Revision Policy

As part of your order, you receive free and unlimited revisions. We are committed to ensuring you submit flawless papers. Only modifications and adjustments that were not successfully satisfied in the initial order should be included, if they are within the guidelines indicated in the order form. These guidelines include:

  1. Your revision instructions should not contradict your original instructions.
  2. Before approving your purchase, you can request a modification at any moment, but you have a 14-day grace period during which you can do so
  3. Your deadline date should never be too close to your original deadline date

Privacy Policy

We take the privacy of our client’s information very seriously at Assignments123. We never disclose any of our dealings with third party services. No one will know you hired one of our assignment writing services to complete your papers.

We also guarantee our customers online security when using our website. All your personal information and passwords are encrypted and are not accessible to any other user apart from you. We also reassure our customers that their accounts cannot and will not be subject to any form of cyberattacks such as hacking. Find more information on the data we collect and store in our privacy policy.

24/7 Customer Support

Feel free to reach out to us via email, phone, or live chat. We love to hear from our customers and we appreciate any feedback you have regarding our assignment help service. We have customer service representatives available around the clock, including holidays, and weekends, whether it is to place an order, check on the status of your order, or for inquiries.

You can choose to chat one-on-one with your assignment expert through our assignment help website’s live chat. You have unlimited number of chats with our verified professionals. We will respond to any of your queries in minutes.

Quality Academic Papers

Our expert team of editors and writers consists of individuals with a diverse variety of writing experience. They are all Ph.D. or M.A. graduates with extensive experience in both their academic fields and the essay writing industry. We guarantee high-quality, unique academic writing at an affordable price.

We write every order from scratch, ensure your papers adhere to standard English conventions, as well as the requirements of your discipline. We also run originality reports on all your academic papers to guarantee their originality. We have a success rate of 99%, with many of our clients attaining their desired grade.

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency