Unit 14 Review
Created on May 5, 2023
Match each description with its housing term:
Involves a short period of time for the temporary use of an asset
Involves a pre-determined period of time with specific conditions and required maintenance
Involves a title of ownership with specific taxes and payments required
Which option would be more cost effective if you plan to stay for only 8 months?
Apartment B costs $800/mo for an annual contract, but that includes a 2-month early termination penalty.
Apartment A costs $950/mo for a month-to-month contract.
Which option is most likely to be more cost effective?
Apartment B costs $625/mo with utilities included.
Apartment A costs $450/mo plus $200 for utlities.
Which has a lower cost of living, the new residence or the current residence?
Find the equity amount for each home.
You purchased for $193,000 and it is now valued at $215,000.
You purchased for $234,000 and it is now valued at $284,000.
Which transportation method is more cost-effective for the year if you work 5 days a week?
Taking the Bus:$7.50/one-wayNeed 2 tickets per day
Driving Yourself:Gas - $50/WeekCar Insurance - $550/YearOil Changes - $45/Quarter
Your car insurance is due annually and generally costs about $2,000. You decide that you would like to set aside a monthly amount, beginning in January, to be prepared for when this bill comes at the end of the year. How much should you set aside each month?
You are planning to rent a townhouse. Your monthly rent will be $850, and your renter's insurance will be $1,500 per year. What is the adjusted monthly cost for renting this townhouse?
Adjusted Monthly Payments
Which formula would accomplish this?
Suppose you need to rank the value from A2 in an Excel spreadsheet against the rest of column A. You want the values to be in ascending order.
=RANK(A:A, A2, 0)
=RANK(A2, A:A, 1)
=RANK(A2: A:A, 0)
=RANK(A:A, A2, 1)
complete Unit 14 TestWednesday 5/10 - Flex day (no classes)Monday 5/15 - Unit 15 Project