Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask Financial Management Expert

Finance


Home >> Financial Management

Present Values:

Please provide the calculations in MS Excel for the present value of an $7,000 goal in 7 years at 7% discounted on an annual, semi-annual, quarterly, monthly, and daily basis to the nearest penny.

Future Values:

Please provide the calculations in MS Excel for a future value of an $7,000 investment today in 7 years at 7% compounded on an annual, semi-annual, quarterly, monthly, and daily basis to the nearest penny.

Present Value of an Annuity:

Please provide the calculations in MS Excel for the present value of an annuity amount for an $7,000 payout annually in 7 years at 7% discounted on an annual basis to the nearest penny.

Please provide the calculations in MS Excel for the present value of an annuity due amount for an $7,000 payout annually in 7 years at 7% discounted on an annual basis to the nearest penny.

Future Value of an Annuity:

Please provide the calculations in MS Excel for the future value of an annuity amount for an $7,000 payment annually in 7 years at 7% compounded on an annual basis to the nearest penny.

Please provide the calculations in MS Excel for the future value of an annuity due amount for an $7,000 payment annually in 7 years at 7% compounded on an annual basis to the nearest penny.

Interest Rate Calculation:

Calculate the interest rate to the nearest basis point (0.0001) for a $40,000 investment with an $70,000 financial goal for 7 years. No payments will be made during the 7 years.

Number of Periods Calculation:

Calculate the number of years needed to earn $70,000 with a $50,000 initial investment earning an 7% annual interest rate. Please round to the fourth decimal place. No payments will be made during the 7 years.

APY or EAR:

To the nearest basis point, calculate the yield of 17% on a semi-annual, quarterly, monthly, and daily basis utilizing equation 4.14 on page 167.   Show all calculations in MS Excel to the fourth decimal place.

Loan Amortizations:

Please construct an annual loan amortization table for a loan of $40,000 for 4 years at 7%. Please utilize figure 4.11 on page 172. You will have to find the payment first before constructing the amortization table. Make sure to provide the number of periods, the beginning balance, the payment, the interest dollar amount, the principal dollar amount, and the ending balance for each of the five years.

Financial Management, Finance

  • Category:- Financial Management
  • Reference No.:- M92868391

Have any Question?


Related Questions in Financial Management

Part 1 conduct internet research sources must be documented

Part 1. Conduct Internet research, (sources must be documented using MLA format), and write a brief analysis of the current status of the U.S. economy. Include current values and trends for at least three of the followin ...

Topic dash dietthere are many different diets weight loss

Topic: DASH DIET There are many different diets, weight loss treatments, and medications that proclaim to be the panacea for weight loss. For this discussion forum, you will be researching a diet or treatment approach fo ...

This week will develop the theory and application of

This week will develop the theory and application of capital budget analysis. The theory was robust, the calculations mathematically and logically defined, and many of the real-world problems, likely to be encountered, w ...

Process improvement projectfor this assignment select

Process Improvement Project For this assignment select either your own organization or an organization about which you know enough to review the supply chain processes and identify a process that can be improved in your ...

You will be conducting an interview with a market research

You will be conducting an interview with a market research professional or a company representative. Use the results of your research to make specific recommendations on how market research can be applied to the Marketpl ...

Part 1 trade receivables1 for purposes of answering the

Part 1: Trade Receivables 1. For purposes of answering the questions in this part, only consider "Trade Receivables." a. What is the amount of Trade Receivables that customers owe Coors at the end of fiscal 2002? b. What ...

Guidelines for forecasting work in ceres gardening casethe

Guidelines for forecasting work in Ceres Gardening Case The analysis of Ceres Gardening should focus on forecasting the Income Statement, Balance Sheet and Statement of Cash Flows for years 2007-2009, as indicated on the ...

Discussionbull profits and risks of off-balance-sheet

Discussion • Profits and Risks of Off-Balance-Sheet Activities • The difference between spot and forward exchange rates. What role do currency swaps play? • The Federal Open Market Committee • Multiple Deposit Creation a ...

Grounded theory and ethnography assignment instructionseach

Grounded Theory and Ethnography Assignment Instructions Each qualitative design is slightly different from the others; these differences are important for researchers to consider when selecting a design that is most appr ...

The following examination is due no later than 9 am monday

The following examination is due no later than 9 AM Monday, October 22nd. You are to email me the exam in an XLSX file named after yourself and containing your section. For example, if your name is Leslie King, the file ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As

Follow Us

© Copyright 2013-14 mywordsolution.com All rights reserved