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.

GOALS OF THIS PROJECT:

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.

ASSUMPTIONS/DETAILS

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

Questions Cloud

Evaluate the success of the overall strategy : Assess the techniques used by QinetiQ for improving business processes and evaluate the success of the overall strategy.
Evaluate the effectiveness of stms strategy : Evaluate the effectiveness of STM's strategy of combining as many existing initiatives as possible in order to simplify their approach to TQM.
What kind of product or service does the business produce : What kind of product or service does the business produce? Is it identical to others in the industry or is it differentiated to some degree or perhaps unique
Basics of code development on linux and cryptography : Prepare a C program that gives simple mono-alphabetic substitution between plaintext, and Enhance your code to use "-e" to encrypt a string argument and "-d" to decrypt it using argv and argc
Develop monthly cash flow diagrams : Develop MONTHLY cash flow diagrams and analyze the OWN vs. LEASE options to determine which is the better situation.
Declines to honour the express warranty : Andy declines to honour the express warranty he made to her at the time of the sale. Big Finance Co. sues Amanda for non-payment. In general, any defence that Amanda may have against Andy is good against Big Finance Co
Determine the cost of equity based on capm : Determine the cost of equity based on CAPM? Compute the firm's WACC? Estimate the cash flow for each year of this project
Prepare a balanced scorecard for the unit : Prepare a Balanced Scorecard for the unit of an organization of your choosing (Red Lobster).The organization may be Red Lobster (the restaurant).
Decision productivity and competitiveness : Identify strengths as well as weaknesses in the areas such as follows- Decision making, productivity, competitiveness, morale, management turnover, compensation and so on

Reviews

Write a Review

 

Financial Management Questions & Answers

  Determine operational expenditures

Organisations' behaviour is guided by financial data. In the short term, such data will help determine operational expenditures; in the long term, historical data may help generate forecasts aimed at determining strategic plans. In both instances.

  Evaluate the depreciation on the building

Evaluate the depreciation and what was Happe's Interest Expense on the bond during fiscal year 2012? What was Andersen Telecom's depreciation expense for tax purposes in fiscal year 2012?

  Prepare the statement of comprehensive income

Prepare the statement of comprehensive income and changes in equity

  What is a business plan

Explain how the idea of a brewing device for a small apartment became a startup enterprise. What did you learn from that bit of entrepreneurial history

  Prepare swag''s consolidated balance sheet

Prepare Swag's consolidated balance sheet under and prepare the consolidated financial statements for 20X3 using the direct method

  Calculate the minimum variance and optimal portfolio

Create a model that will automatically calculate the minimum variance and optimal portfolio as well as be able to draw the efficient frontier for a 3 risky asset portfolio.

  Overview of financial management

Overview of Financial Management

  Describe statistical data on participation rates

Describe statistical data on participation rates, education and employment and income levels of individuals with disabilities

  Complute the capital asset pricing model

Compute the CAPM-β of the portfolio with respect to the market

  Maximization of shareholder wealth

Maximization of shareholder wealth

  Determine the cost of equity based on capm

Determine the cost of equity based on CAPM? Compute the firm's WACC? Estimate the cash flow for each year of this project

  Long term financial planning

This assignment is designed for analyze Long term financial planning begins with the sales forecast and the key input in the long term fincial planning.

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