Highway private seller $25,490 19 31 25 dealer $17,998 Maintenance/Year Registration Fee Insurance/Year $600 $300 $1,000 $700 Yearly Costs Need Loan?...
i need help with excel project , its due in a few hrs
Vehicle PurchaseVehicle 1 Description Vehicle 2 2011 Ford Mustang GTVehicle TypePassenger 2012 Honda Civic LXPassenger SellerPriceMPG CityMPG Highway private seller$25,490193125 dealer$17,998 Maintenance/YearRegistration FeeInsurance/Year $600 $300 $1,000 $700 Yearly Costs Need Loan? NO Amount to BorrowAPRYears NO$20,4904.90%5 $12,9981.90%4 GasLoan PaymentMaintenance/MonthInsurance/MonthTotal Monthly $209.55$294.00$50.00$83.33$636.88 $201.22$22.80$25.00$58.33$307.35 Affordable? YES YES Monthly Costs AnalysisVehicle 3 Vehicle 4 2013 Ducati Superbike 848 EvoMotorcycle 2012 GMC Canyon Regular CabTruck private seller$13,9954444$30 Average dealer$17,475182521.5 PriceMPG CityMPG HighwayMPG AverageYearly CostsMaintenanceRegistration Fee Average Insurance$500 $500 $1,500 $600 NO LoanAmount to Borrow NO$8,995 \2$211.22Err:511$41.67$125.00$419.68YES $12,4753.90%3$208.38$46.80$41.67$50.00$346.85 Average APRYearsMonthly CostsGasLoan PaymentMaintenanceInsuranceTotal Monthly Average Highest Lowest Highest Lowest Highest Lowest Highest Lowest Vehicle Purchase Assumptions$5,000 Total Cash Available for Vehicle Purchase$600 Total Monthly Amount Available to Pay for Operating Vehicle600 Number of Miles I Expect To Drive Each Month$3.65 Gas Price Per Gallon Registration feescolumn # 1 Cargo VanFarm VehicleMotor HomeMotorcyclePassengerTaxicabTrailerTruck 2 100681006010016030100
Show more
