FINA 4920 E: FINANCIAL MODELING SUMMER 2017 PROJECT #2: CAPITAL BUDGETING (DUE: MIDNIGHT, JULY 2nd) NOTE: YOU MAY WORK WITH A PARTNER. YOU MUST IDENTIFY YOUR PARTNER IN THE SUBMISSION NOTES WHEN YOU TURN INYOUR ASSIGNMENT AND ALSO PUT THEIR NAME ON THE SPREADSHEET A car rental agency is considering adding the Kia Soul to its fleet of rental cars. Based on features and a wholesale rate, the agency can buy each Kia Soul for $22,500. As a capital expenditure, the agency can depreciate the Soul using a 5-year MACRS schedule As an analyst, you have been asked to create a project analysis on the new car and assess the value created by adding the Soul. You have been given the following assumptions for the project ASSUMPTIONS sted Rental Price Per Da of rentals Yearly decline in rentals (%) aintenance Costs Per Year Yearly increase in maintenance costs ( Yearly Insurance 1,0 ompany Overhead applied to car Yearly increase in insurance cost (%) Marginal Tax Rate 7.00% CAR MARKET VALUE (MV) EAR MV as % of Need help on part 5 and 6 FINA 4920 E: FINANCIAL MODELING SUMMER 2017 PROJECT #2: CAPITAL BUDGETING (DUE: MIDNIGHT, JULY 2nd) NOTE: YOU MAY WORK WITH A PARTNER. YOU MUST IDENTIFY YOUR PARTNER IN THE SUBMISSION NOTES WHEN YOU TURN INYOUR ASSIGNMENT AND ALSO PUT THEIR NAME ON THE SPREADSHEET A car rental agency is considering adding the Kia Soul to its fleet of rental cars. Based on features and a wholesale rate, the agency can buy each Kia Soul for $22,500. As a capital expenditure, the agency can depreciate the Soul using a 5-year MACRS schedule As an analyst, you have been asked to create a project analysis on the new car and assess the value created by adding the Soul. You have been given the following assumptions for the project ASSUMPTIONS sted Rental Price Per Da of rentals Yearly decline in rentals (%) aintenance Costs Per Year Yearly increase in maintenance costs ( Yearly Insurance 1,0 ompany Overhead applied to car Yearly increase in insurance cost (%) Marginal Tax Rate 7.00% CAR MARKET VALUE (MV) EAR MV as % of