Take on the role of a consultant to Moira Lafort, complete the following analysis using the excel templates

Take on the role of a consultant to Moira Lafort, and complete the following analysis using the excel templates* provided: *Cells that require your input are highlighted in green. Do not modify any of the non-green cells.
1. On the “Schedules” worksheet:
a) Determine the total investment required to start the Harbourfront Pharmacy by filling in the information per the template provided.
b) Determine the amount of additional debt financing Lafort needs to cover the investment (cell B11).
c) Fill in the variable cost as a % of sales schedule with the information as provided in the case.
d) Fill in the fixed cost schedule. Use straight line depreciation/amortization for the fixed assets and franchise fee.

  1. Place this order or similar order and get an amazing discount. USE Discount code “GET20” for 20% discount