Analyze the numbers in the problem

Assignment Help Financial Management
Reference no: EM13969875

I have included a simple capital investment problem which is in Course Documents. We are going to use the same numbers for several classes and look at some of the ways that capital investments are evaluated.

This week we will look at the pay back method. This method looks at how long it takes to get the money back from an initial investment or cash outflow. There is an extensive amount of information on the internet if you run into trouble on this.

To get full credit please do the following: Define the technique.

Analyze the numbers in the problem using an excel spreadsheet. You must use Excel formulas which are on the ribbon in Excel marked Fx to make your calculations whenever possible.

All information must be in Excel (Word documents will not be read and you will not get credit).

Attachment:- Capbudget.xls

Verified Expert

As desired, the enclosed solution is framed in excel format. The question on Payback period for capital budgeting is calculated based on the formulas in excel, i.e., by use of fx ribbon. The solution substantiates the fundamental of the subject and and meets all the requirement mentioned in the question.

Reference no: EM13969875

Questions Cloud

What is the periodic rate and effective rate of interest : Your bank your bank pays 8% nominal rate of interest. The interest is compounded quarterly. What is the periodic rate and effective rate of interest
Find the volume of the tetrahedron : Find the mass of the region R bounded and find the volume of the tetrahedron
Explain how useful you think the bsc is : Discuss with your group your recommendations and best practises for utilising BSCs in general. Note the various formats that may be used across examples, and discuss any advantages you may see to one style of presentation over another.
Critically discuss the given statement : It is not possible to give effect to informal trusts of land. Paul v Constance [1976] EWCA Civ 2 established that effect could be given to informal trusts of personal property if circumstances justified it.
Analyze the numbers in the problem : Analyze the numbers in the problem using an excel spreadsheet. You must use Excel formulas which are on the ribbon in Excel marked Fx to make your calculations whenever possible.
Prepare power point presentation on amazon proposal : Prepare power point presentation on given Amazon Proposal
Write a proposal paper on amazon : Write a Proposal paper on Amazon - The brand of Amazon was born out of the insight that there can be evolution of internet as a source for targeting the customers and selling key products.
How did your teaching plans coincide with what occurred : How did your teaching plans coincide with what occurred in the classroom during the week in terms of setting objectives, planning learning activities, organizing learning activities, and specifying evaluation procedures?
Describing two social movements : Describing two social movements. Explain how they started and how they ended, what their purpose was,

Reviews

Write a Review

Financial Management Questions & Answers

  Foreign company acquisition

Acquisition by a foreign company and the effects of that decision and the results of foreign exchange in Euro and the exchange rate differences.

  Financial management for profit and non profit organizations

In this essay, we are going to discuss the issues of financial management in a non-profit organisation.

  Method for estimating a venture''s value

Evaluate venture's present value, cash and surplus cash and basic venture capital.

  Replacement analysis

This document show the Replacement Analysis of modling machine. Is replacement give profit to company or not?

  Business finance task - capital budgeting

Your company is considering using the payback period for capital-budgeting. Discuss the advantages and disadvantages of this technique.

  Analysis of the investment

In this project, you will focus on one of these: the additional cost resulting from the purchase of an apple press (a piece of equipment required to manufacture apple juice).

  Conduct a what-if analysis

Review the readings and media for this unit, including the Anthony's Orchard case study media. Familiarise yourself with the Anthony's Orchard company and its current situation.

  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.

  Personal financial management

How much will you have left over each half year if you adopt the latter course of action?

  Sources of finance for expansion into new foreign markets

A quoted company is considering several long-term sources of finance for expansion into new foreign markets.

  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.

  Explain the role of fincial manager

This assignment explain the role of fincial manager, function of manger. And what are the motives of financial manager.

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