Develop monthly cash flow diagrams

Assignment Help Financial Management
Reference no: EM135320

You are expected to spend a good amount of time researching, analyzing and producing your project report. Your project will be evaluated on the basis of data collection and analysis accuracy (worth 20 pts), thoroughness/detail (20pts), the appropriate use of tools and methods discussed in the course (worth 20 pts), and the quality/clarity of the project report (20 pts). Note: BOTH Project #1 (mutual fund investment scenarios) and THIS project are due on the last day of class.

Your submitted report should follow proper business report writing standards (preferably typed and in PDF format, with electronic supplements such as Excel files also submitted) and include: (a) an Executive Summary that briefly describes your results, methods, and recommendations, on one page, (b) print-outs or an Excel file of collected data listings including Excel-based CFDs, pricing data, purchase data, etc., over the time period studied, (c) print-outs or Excel file containing the analysis performed, and (d) additional written details that describe your assumptions, the steps you performed, the rationale behind your conclusions, and your uncertainties that the report reader should be aware of.


A. Research your assigned vehicle to estimate or determine all costs associated with owning OR leasing a vehicle, and operating this vehicle for 3 years, based on the assumptions mentioned below.

B. Develop MONTHLY cash flow diagrams and analyze the OWN vs. LEASE options to determine which is the better situation.


1) You must assess acquiring the vehicle in one of 2 ways (and will be comparing these options):

a. purchase the vehicle NEW using $3,000 of your own money, and the remainder of the initial cost with a car loan ?from either a local bank or from the dealer, at the bank or dealer's current lending rate, OR

b. lease the NEW vehicle by making the down payment specified by a vehicle dealer, and making payments as ?specified by the lease agreement (seek out lease arrangement details from the manufacturer's or dealer's ?website).

2) You will make loan or lease payments MONTHLY, and the CFD and analysis must be on a monthly basis (36 months).

3) You will drive your selected vehicle a customary amount (similar to your own personal driving pattern) BUT if you do not ?drive much, assume you will drive this vehicle to/from work and/or school AT LEAST 10 miles each way, at least 5 ?days/week, for at least 2 semesters each year.

4) Assume you will use the vehicle for some additional pleasure driving, to places you normally would go each year (for ?example, to Northern Michigan during the summer or to visit relatives in another state), so add on these extra miles of use.

5) Assume the vehicle fuel economy is that promised by the manufacturer (city and highway); estimate your city and highway ?driving percentage so you can develop a composite MPG value for your driving pattern; assume fuel cost is $3.25/gal.

6) Whether leasing or owning, you will insure the vehicle with a reputable insurance company (web-based insurance company ?quote is OK to use as your expense) and you will maintain the vehicle (oil changes, tire rotation, filter replacement, etc.) based on the manufacturer's regular schedule. Regardless of whether you purchase or lease, assume you must pay all insurance and maintenance costs.

7) While owning or leasing, assume you will NOT experience any accidents or damage that would reduce the value of the vehicle beyond normal wear and depletion.

8) (AFTER 3 YEARS = 36 months) If purchased, you will sell the vehicle at a fair price that you estimate based on past data that you collect for similar aged vehicles of this model or brand. If you lease the vehicle, you will be turning in the vehicle (with no salvage) upon making the last lease payment.

9) The document "PILKINGTON CASE STUDY" has been uploaded to Blackboard. YOUR study will be DIFFERENT than the Pilkington Case, but you can use this document for some ideas on what/how to cost and analyze your options.

Reference no: EM135320


Write a Review


Financial Management Questions & Answers

  Financial management and markets

Problems on Financial Management and Markets

  Evaluate each franchise''s npv

According to the NPV, which franchise or franchises would be accepted if they are independent? Which could be accepted if they are mutually exclusive? Evaluate each franchise's NPV? Be sure to show your calculations.

  Importance of a balanced capital structure and the problems

The importance of a balanced capital structure and the problems which are associated with high levels of gearing.

  What is the average direct labor cost rate

What is the average direct labor cost rate and What is the overhead rate.

  Complete the financial reporting for each period

Complete the financial reporting for each period

  Describe concept of future value and present value

Describe concept of future value and present value

  Monitor expenditure and compare with financial plan

Report and monitor expenditure and compare with financial plans so that recommendations are developed for key stakeholders.

  What is the default risk premium on corporate bonds

There are questions on Financial Management and Markets. Like What is the default risk premium on corporate bonds?

  Internal rate of return and net present value

Internal Rate of Return and Net Present Value

  Determine the constant growth rate in dividends

Arbitrage Financial is offering two possible investments with the same level of risk.

  Prepare a line graph

Prepare a line graph showing the budgeted total revenues and total expenditures

  What is a ruined cost

What is a ruined cost. Why is it important to understand this concept when analyzing capital projects

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd