Get instant live Excel expert help to learn how to apply financial function in Excel?

I work at an Investment Bank, and am currently conducting a churn analysis. Essentially, this requires us to track which customers cancelled their contracts with our client. The issue is that the data is listed by account in one column, but that there are multiple accounts for a given customer. For example, if Walmart were a client, there might be 50 accounts for Walmart, each in a different city. How might we be able to combine all these entities, without running a manual process, as the file contains well over 60,000 accounts?

how would i do this question on excel? An investment will generate £15,000 a year for 20 years. If you require a rate of compensation of 10% and the investment costs £100,000, show whether it is worth buying? If expected inflation is instead estimated to be 2% higher, show how this impacts on your recommendation.

I would like to develop an excel template that manages my investment portfolio and presents performance on a dashboard

Company A is considering launching a mobile streaming service for episodic television content. We would license the content for this streaming service on a quarterly basis for a flat fee per TV series. The service is free to customers, i.e. no subscription fee to access the content, and it generates revenue by displaying advertisements between episodes of each show. Advertisements are typically shown at the start of each episode, except for the first episode in each TV series. There are three types of TV content to consider: A, B, and C. We have included Q3 2017 data for each of the three types of content by TV episode, licensing fees by type of content, and average eCPMs received from our advertising partners. Key assumptions to augment your analysis can and should be sourced from any public resource available. You are the strategic finance analyst assigned to this initiative. Your responsibility is to provide a recommendation for how much to invest in new content and the allocation of your investment to each type of content over the next year. Please consider both quantitative and qualitative factors in your recommendation. You are expected to include KPIs and metrics in your analysis. Please perform your data analysis in Excel and include your scratch work. We will be evaluating the basis of your analysis as well as your final recommendation.

Suppose you are consultant for a farmer who owns 100 acres of usable land. She wants to plant some combination of corn and wheat on the land. She wants you to build a spreadsheet that will calculate NPV and IRR based on her estimates for costs and revenues related to this project. Create an NPV analysis template that the farmer can use to make the optimal investment decision. Use the following template. Excel HW #4 - template.xlsxPreview the document "Assumptions" Tab Insert placeholder data of your choosing into yellow input cells Create dynamic calculations for all non-input cells "Worksheet" tab Create dynamic calculations using data from assumptions tab "ROI" Tab Create dynamic cash flow calculations for each year using data from the other tabs Use excel formulas to calculate NPV and IRR based on the net cash flow data Use conditional formatting to indicate when the NPV and IRR indicate a good investment "Scenarios" Tab Answer the questions relating to each scenario using your completed spreadsheet as the calculator Seek help from classmates and/or TAs as necessary. Upload your completed file to Canvas prior to the due date

Trying to make sheet on retirement withdraws. Cell A would be Year, Cell B would be cash value C would be 3% withdraw (in dollars), D would be expected % gain on investment (I want to be able to change this as economy changes) I want to subtract C dollars from B for that total then I want sum of b - c then add the percentage of d for an estimate of how much I would have left. What I mean to be conservative I want to subtract my withdraw before I calculate the gain using gain percentage formula.

Inheritance of $200,000 to return a maximized investment. Three posibilities; Cds which pay garuntee 6%, Stocks with a return of 13%, and Money Mutual Funds with an 8% return. The amount in stocks can not exceed 1/4 of total amount invested. Risk Factors; CDs 1.2, Stocks 4.8, money mutual funds 3.2 Risk factor for the whole investment has to be less than 3.3

i need help with pivot tables, my return on investment column is messed up

Create an Excel spreadsheet comparing simple and interest compounded monthly and yearly for an investment of $4000 over 20 years with an APR of 2.5%. How do i enter this as compounded monthly formula and a yearly formula

I need help solving a investment problem using excel solver(optimisation)