Question: 13 Enter the reference to the Monthly Payment function in the correct location for a two-variable 3 data table. 14 Complete the two-variable data table

13 Enter the reference to the Monthly Payment13 Enter the reference to the Monthly Payment13 Enter the reference to the Monthly Payment
13 Enter the reference to the Monthly Payment function in the correct location for a two-variable 3 data table. 14 Complete the two-variable data table and apply Comma Style to the range K5:M16 with no 9 decimal places.Exp22_Excel_Ch06_Cumulative_AutoSales Project Description: You are the finance manager for Grossman Auto Sales. Your company offers in-house financing and as part of your duties you create reports detailing purchase options. You want to create a report to determine the optimal purchase price of a vehicle based on your customer's budget. You also want to create one- and two-variable data tables to provide detailed payment options based on varying interest rates and down payments.Grossman Automative Input Purchase Price Down Payment Tax Monthly Pmt $500.00 $ 5,000.00 $ 10,000.00 $ 15,000.00 Purchase Price $36,297.11 20,000.00 2,000 1,400 276 20,000.00 Sales Tax 7% 25,000.00 2,500 1,750 344 25,000.00 #REF! #REF! Down Payment 10% 30,000.00 3,000 2,100 413 30,000.00 #REF! #REF! Months Financed 72 35,000.00 3,500 2,450 482 35,000.00 #REF! #REF! APR 3.25% 40,000.00 4,000 2,800 551 40,000.00 #REF! #REF! 45,000.00 4,500 3,150 620 45,000.00 #REF! #REF! Output 50,000.00 5,000 3,500 689 50,000.00 #REF! #REF! Down Payment Amount | $ 3,629.71 55,000.00 5,500 3,850 758 55,000.00 #REF! #REF! Amount Financed $ 32,667.40 60,000.00 6,000 4,200 827 60,000.00 #REF! #REF! Tax Owed $ 2,540.80 65,000.00 6,500 4,550 895 65,000.00 #REF! #REF! Monthly Payment $500.00 70,000.00 7,000 4,900 964 70,000.00 #REF! #REF! 75,000.00 7,500 5,250 1,033 75,000.00 #REF! #REF

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!