FIN 486 - WEEK 3 - long-term financial needs.

profileputul
 (Not rated)
 (Not rated)
Chat

You are the head of the Huffman Trucking accounting department. The chief executive officer (CEO) has asked you to prepare a financial report addressing long-term financial needs.

Resource: Virtual Organizations web link

Examine financial information for Huffman Trucking, within the Virtual Organization web link located on the course materials page. Read the New Strategic Directions Memo. Calculate external funds needed (EFN) to create the pro forma balance sheet. Calculate the following year-end ratios for the pro forma statements:

·        Profit as a percentage of sales

·        Current ratio

·        Asset ratio

Prepare a 700 to 800 words financial report for the CEO containing the EFN calculation, the ratio calculations, and an explanation of how you reached the calculations. Explain which income statement and balance sheet items you assumed were variable instead of fixed.

Format your paper consistent with APA guidelines

    • 9 years ago
    Excel calculation given + paper - MEANT to be used as guide for A+++++ work
    NOT RATED

    Purchase the answer to view it

    blurred-text
    • attachment
      answer.docx
    • attachment
      excel_calculations.xls