First Blank --> 3,584, 2016, 3920

Second blank --> 25,412, 22,097, 16573

Please show me how you find the calculation for PV. I need to know what you put into excel. Thanks

Second

3. How much car can I afford? Aa Aa E How Much Car Can I Afford? Before buying a car, it is critical that you determine both the complete price of the vehicle and what you can afford to spend. This information is essential in deciding whether to pay cash or finance the vehicle with a loan. The difference between these two methods of payment, however, is the difference between paying the car's full price versus making a much smaller down payment and fitting the monthly payments into your budget. There are two schools of thought about how much car you can afford. Financial experts recommend that the amount of your car payment not exceed 20% of your net monthly income. Others suggest that if you can accommodate the payment in your budget, then it's acceptable-although you shouldn't obligate yourself to eating rice cakes for the next four years. Emma is a 38-year-old woman whose current gross monthly income is $2,800. Given an average personal tax rate of 28% for her federal, state, and local taxes, Emma's net monthly income is If she follows the advice of financial experts, what is the maximum amount that she should spend to purchase a new vehicle? (Note: Round your answers to the nearest whole dollar.) $1,210 $403 $2,016 An alternative to the 20% rule is to evaluate your budget, determine a monthly payment that you can reasonably afford, and then incorporate that information with the maturity and interest rate of a possible loan to determine the value of the potential loan. When this value is added to a saved amount of a down payment, you know the total amount that you can reasonably afford to spend on a new car. To review this process, consider the following case: To review this process, consider the following case: Emma's Car-Buying Decisions Emma, who lives in Houston, is trying to decide between the following car models: Brand and Model Ford Fiesta Toyota Prius Kia Sorento Porsche Boxster Cost $13,580 19,895 23,150 48,100 She's currently accumulated a down payment of $4,000, and she has determined that she can afford maximum payments of $425 per month. Her initial research on the current cost of auto loans has found that her lowest cost loan would be made by a bank and would require an interest rate of 6% for four years. , and Given this information, the maximum amount that Emma can afford to pay for her new car is the most expensive car that she can afford to purchase, without stretching her budget, is: O Emma shouldn't buy a car at this time due to her limited budget The Ford Fiesta The Toyota Prius The Porsche Boxster The Kia Sorento However, she could upgrade to a more expensive model by undertaking several activities. Which of the following activities would allow this upgrade? Check all that apply. Purchase the more expensive car now and then ask her boss for a raise next week Take a better-paying job or another, or part-time, job that would give her the additional income to support a larger monthly payment Postpone her purchase until she can save more money for a larger down payment Purchase the more expensive car now and figure out later how to pay for it