Final test 1 2241

.xlsx

School

Toronto Metropolitan University *

*We aren’t endorsed by this school

Course

ACC100

Subject

Finance

Date

Feb 20, 2024

Type

xlsx

Pages

43

Uploaded by CoachProtonStingray38

Enter your name below in the yellow Enter your student number below in the yellow Avneet Sidhu 162029227 Nothing below here nb n.
Suburbia Shopping Mall Your City Company Years Expiration Date Sq. Feet Annual Rent Fillards Dept Store 1/1/2010 5 1/1/2015 6,500 Boomingbales 1/1/2010 10 1/1/2020 6,750 Freddie Bauder 5/5/2011 3 5/5/2014 2,000 Inner Gap 12/1/2011 2 12/1/2013 3,250 Screaming Kids Inner Gap 7/1/2011 1 7/1/2012 2,150 Mallmart Cards 2/14/2010 5 2/14/2015 2,150 Hollingster 11/15/2011 2 11/15/2013 2,900 Fancy Jewelry Store 1/1/2010 4 1/1/2014 1,200 Spinster's Gifts 4/15/2011 1 4/15/2012 1,200 Waldo's Bookstore 5/17/2012 3 5/17/2015 2,150 Leasing Lookup Table Price Per Sq Foot Term (Years) Regular Adjusted 1 $ 25.00 $ 24.00 2 $ 22.49 $ 22.00 3 $ 19.99 $ 18.50 4 $ 19.23 $ 18.00 5 $ 19.00 $ 17.00 10 $ 16.99 $ 15.00 Constants Square Footage Threshold 3,000 Months Per Year 12 Occupancy Date Price per Sq Ft The threshold in the In this scenario, two kinds of rent can be a threshold of the designated rent and the o the designated rent, as shown in the table the table to calculate the applicable rate p logic functions if and vlookup. Anything el
Monthly Rent e lookup accessed/used. One is for below the other is above the threshold above e named “Leasing lookup table”. Use per square foot. You MUST use the lse is unacceptable.
Borrow Lease Lease value of Car 120000 125000 Down Payment 25% 10% Length of lease in (years) 5 5 APR (annual interest rate) 5% 5% Residual (Buy back) 20% Monthly lease payment Total interest paid on Loan You ar the le 1. Mo 2. Tota
re required to calculate two things in the space provided to eft: onthly lease payment. al interest paid
January February March April May Monthlty descrease 10% 100000 110000 121000 133100 146410 NewFoundland 5000 5500 6050 6655 7321 PEI 3000 3300 3630 3993 4392 Nova Scotia 2000 2200 2420 2662 2928 Quebec 32000 35200 38720 42592 46851 Ontario 26000 28600 31460 34606 38067 Manitoba 10000 11000 12100 13310 14641 Sascatewan 6000 6600 7260 7986 8785 Alberta 8000 8800 9680 10648 11713 British Columbia 8000 8800 9680 10648 11713 Totals 100000 110000 121000 133100 146410 NewFoundland 5% PEI 3% Nova Scotia 2% Quebec 32% Ontario 26% Manitoba 10% Sascatewan 6% Alberta 8% British Columbia 8% 100% There is an infectio this infection based absolute and mixed your marks, you m
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help