Finance Assignment | Professional Writing
Margaret recently purchased a used car from Buckeye Honda for $22,773. The car cost Buckeye $15,067, and another $3,950 was needed to do the necessary body work and detailing. Margaret drives her car about 15,000 miles a year and has signed up for Buckeye’s regular maintenance reminders, explaining that she wants to keep her car running in good order but that she herself has neither the time nor the skill set necessary to do so.
These regular maintenance appointments are scheduled for every 7,500 miles and Buckeye’s average profit on them is $218. Calculate Margaret’s total CLV to Buckeye Honda including the initial purchase and service, assuming a three-year time horizon.
Please post the Excel formulas
Get Finance homework help today