UW Farmcy Inc Excel Spreadsheet
Description
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.
Have a similar assignment? "Place an order for your assignment and have exceptional work written by our team of experts, guaranteeing you A results."
