Get instant live Excel expert help to learn how to apply financial function in Excel?
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
Needs to create revenue assumptions and some sensitivity analysis to see what makes sense to carry into a 10-year forecast.
Specific Instructions
1.Develop recommendations on both the financial feasibility of purchasing the CyberKnife – should the facility move forward with this investment? The supporting analyses should include price (net revenue/unit) development (sensitivity analysis around net revenue, sessions, 10 year revenue projection (can look at more than 1 scenario if you wish) and associated cash flow projections, NPV calculation. Consider if a bundled service offering is the best way to go.
Solved by T. H. in 28 mins
Hello, putting together a projection where for every $100K in revenue i want to add 1 new real estate investment. im using "IF" fucntions, but if I made 300K in one year id want to add 3 units per this projection, but my IF function only adds 1 if revenue is greater than $100K
Solved by S. H. in 12 mins
What will give you more money: An investment of $25, 000 now with
10% annual return for 30 years, or an investment of $150, 000 (made after
twenty years) for 10 years at the same rate of return. Both investments
mature at the same time. This exercise shows why it is helpful to begin
saving early.
Solved by S. U. in 13 mins
Financial Excel Formula Needed on a Spreadsheet that can calculate NPV of an investment of $11,000 using a discount rate of 1%.
Solved by X. H. in 18 mins
i. Develop and enter the appropriate Excel formulas to calculate: the initial amount invested in each
stock, the profit (or loss) when you sold the shares of that firm, and Return on Investment (ROI).
D. For the entire portfolio: (1 pts)
i. Enter Excel formulas to calculate Total Amt Invested, Total Gain Amt (or Total Loss Amt) and Total
ROI of the entire portfolio. (Hint: Total ROI is not sum of individual ROIs. To compute the Total ROI
on the entire portfolio, use the total profit (or total loss) on the portfolio and the total amount invested.)
Solved by K. A. in 23 mins
Develop and enter the appropriate Excel formulas to calculate: the initial amount invested in each
stock, the profit (or loss) when you sold the shares of that firm, and Return on Investment (ROI).
D. For the entire portfolio: (1 pts)
i. Enter Excel formulas to calculate Total Amt Invested, Total Gain Amt (or Total Loss Amt) and Total
ROI of the entire portfolio. (Hint: Total ROI is not sum of individual ROIs. To compute the Total ROI
on the entire portfolio, use the total profit (or total loss) on the portfolio and the total amount invested.)
Solved by T. H. in 22 mins
I need a column E (first investment date of the firm into 1 company) that calculates the minimum of column D (investment dates). A firm (column A) invests in a company (column C), however, multiple firms can invest in one company. Thank you in advance for the help!
Solved by D. F. in 26 mins
Display Sheet1 and rename the sheet as Investment Sources. Click in any blank cell to cancel any selections. In cell A12, type Goal: Increase Endowment Fund from 8% to 10% and then Merge & Center the text across the range A12:D12. Apply the Heading 3 cell style. In cell A13, type Goal Amount.
Solved by C. S. in 11 mins
Add Minimum Cost and Maximum Cost rows that are formatted similarly to row 50 (Average Cost row). Use functions to calculate the minimum and maximum costs for the systems purchased.
Convert the Initial Cost data including the Average Cost, Minimum Cost, and Maximum Cost, and the Depreciated Value data from a generic number to accounting format with no decimal places.
Copy the average, minimum, and maximum functions to the Depreciated Value columns.
Merge and center the title “Desktop & Laptop Systems Inventory & Depreciation” above all of the columns with data.
The CEO has asked you use conditional formatting to create an easy visual on the spreadsheet of any device that is near the end of its useful life. Utilize conditional formatting for all columns that contain a depreciated value of less than $500 they will appear red.
Create a pie chart to show the initial cost totals by department. You may create a set of summary data to the right of the current data to use for the creation of your chart.
Solved by Z. A. in 24 mins
Need formula to calculate depreciation excel on an asset sold prior to it's service life AND prior to full year
Solved by E. U. in 12 mins