1-A. Decision-Making Process Financing a New Vehicle Be creative and original I provided my template for your guidanceAutomate appropriately Research and create your own test data using a real auto that you would like to purchase What Type of Information System? What are your concerns, and final decision? 1-B. Decision-Making Process Financing a New Home Do the same, except you are now financing a new home and automate appropriately Becreative and original I provided my template for your guidance Automate appropriately Research and create your own test data using a real home that you would like topurchase What Type of Information System? Purple-Data Entry Black-Headings Function/Formula/Calculations Loan Duration in Months Annual Percentage Rate Down Payment 36 3% 48 4.00% 60 4.90% ($221) ($242) ($202) ($220) ($183) $4.000 ($342) ($265) $5,000 ($313) $6,000 ($284) Subaru Legacy Limited 72 5.50% ($192) Monthly ($175) Payment ($159) Options MSRP Negotiated Discount Selling Price Rebate Total Savings & Rebate Trade Allowance Loan Principle $33,234 $1,500 $31,734 $0 $1,500 $16,000 $15,734