i want questions from 1 to 8 to be solved Recovered Sheet1 CASE25BM Print Area MI PRINT AREA MI CASE25BM Student Version FRIENDLY FOOD STORES, INC. Document Preview: Recovered Sheet1 CASE25BM Print Area MI PRINT AREA MI CASE25BM Student Version FRIENDLY FOOD STORES, INC. Lease Analysis This case illustrates the lease-versus-purchase decision from the standpoints of both the lessee and lessor. The model calculates the NAL (NPV) and IRR of the lease for both the lessee and the lessor. Note that the lessees model is presented in two equivalent formatsa time line format which includes the cost of the equipment in lieu of the financing cash flows, and a time line format which includes loan payments and interest tax savings. Finally, note that the model contains a graph which plots the lessees NAL and lessors NPV at different lease payment amounts. Click on the NAL/NPV tab to view the graph. Click on the CASE tab to return to the spreadsheet. If you are using the student version of the model, the following cells have been blanked out: D32, D36, D47, D66, C80, D81, D95, C97, D105, D112, G138, G143, F176, D177, F181, and C187. Before using the model, it is necessary to fill in the empty cells with the appropriate formulas. Once this is done, the model is ready for use. = INPUT DATA: KEY OUTPUT: (Note: All dollar amounts are stated in thousands.) General Data: For Lessee: Invoice price PV cost of owning Lease payment PV cost of leasing NAL For Lessee Only: IRR Maintenance contract Loan interest rate For Lessor: Estimated residual value NPV of lease RV discount rate (BT) IRR of lease Tax rate For Lessor Only: Opportunity cost rate MODEL-GENERATED DATA: MACRS Depreciation Table: MACRS Deprec Annual Ending Year Rate Basis Book Val ========= PART A: Lessees Analysis: Cost of Owning: Year 0 Year 1 Year 2 Year 3 Year 4 Equip cost Maintenance Maint tax sav Dep shield Residual value RV tax Net owning CF ======== PV cost of owning = Cost of Attachments: Friendly-food.pdf ffriendlyfood.xls; i want questions from 1 to 8 to be solved Recovered Sheet1 CASE25BM Print Area MI PRINT AREA MI CASE25BM Student Version FRIENDLY FOOD STORES, INC. Document Preview: Recovered Sheet1 CASE25BM Print Area MI PRINT AREA MI CASE25BM Student Version FRIENDLY FOOD STORES, INC. Lease Analysis This case illustrates the lease-versus-purchase decision from the standpoints of both the lessee and lessor. The model calculates the NAL (NPV) and IRR of the lease for both the lessee and the lessor. Note that the lessees model is presented in two equivalent formatsa time line format which includes the cost of the equipment in lieu of the financing cash flows, and a time line format which includes loan payments and interest tax savings. Finally, note that the model contains a graph which plots the lessees NAL and lessors NPV at different lease payment amounts. Click on the NAL/NPV tab to view the graph. Click on the CASE tab to return to the spreadsheet. If you are using the student version of the model, the following cells have been blanked out: D32, D36, D47, D66, C80, D81, D95, C97, D105, D112, G138, G143, F176, D177, F181, and C187. Before using the model, it is necessary to fill in the empty cells with the appropriate formulas. Once this is done, the model is ready for use. = INPUT DATA: KEY OUTPUT: (Note: All dollar amounts are stated in thousands.) General Data: For Lessee: Invoice price PV cost of owning Lease payment PV cost of leasing NAL For Lessee Only: IRR Maintenance contract Loan interest rate For Lessor: Estimated residual value NPV of lease RV discount rate (BT) IRR of lease Tax rate For Lessor Only: Opportunity cost rate MODEL-GENERATED DATA: MACRS Depreciation Table: MACRS Deprec Annual Ending Year Rate Basis Book Val ========= PART A: Lessees Analysis: Cost of Owning: Year 0 Year 1 Year 2 Year 3 Year 4 Equip cost Maintenance Maint tax sav Dep shield Residual value RV tax Net owning CF ======== PV cost of owning = Cost of Attachments: Friendly-food.pdf ffriendlyfood.xls
Use the order calculator below and get started! Contact our live support team for any assistance or inquiry.
[order_calculator]