User Account

All Pages

Calculate the total present value of the given cash flow

Assignment Help Accounting Basics
Reference no: EM132246692

Question: Submit your spreadsheet with your template and results for the following questions. Your worksheet should be named "FINC 3733 Excel Project 1_Your Name". Please do not submit before you finish all six questions.

1. Calculate the FV of $500 in 5 years, with 5% interest rate

What if the interest rate is 6%, 7%, 8%......

What if the N changes to 6, 7, 8......

2. Calculate the PV of $500 in 5 years, with 5% interest rate

What if the interest rate is 6%, 7%, 8%......

What if the N changes to 6, 7, 8......

3. Calculate the FV of a 5-year annuity of $500, with 5% interest rate

What if the interest rate is 6%, 7%, 8%......

What if the N changes to 6, 7, 8......

4. Calculate the PV of a 5-year annuity of $500, with 5% interest rate

What if the interest rate is 6%, 7%, 8%......

What if the N changes to 6, 7, 8......

5. Calculate the total present value of the following cash flows when the interest rate is 10% per year:

$100 at the end of year 1

$300 at the end of year 2

300 at the end of year 3

-50 at the end of year 4

6. Construct the amortization table for the 4-year car loan of $10,000 when the APR is 9%.

Reference no: EM132246692

Questions Cloud

Importance to project success : What is quality and its importance to project success and how to explain quality management planning.
What is quality and its importance to project success : What is quality and its importance to project success and how to explain quality management planning
Compose a two paragraph description of hashing : Compose a two paragraph description of hashing that a non-technical user could understand.
Explain how to maintain confidentiality in care home setting : Promoting Effective Communication - Explain how to maintain confidentiality in the care home setting. Describe how to overcome barriers to communication
Calculate the total present value of the given cash flow : FINC 3733 Calculate the total present value of the following cash flows when the interest rate is 10% per year: $100 at the end of year 1.
Likert scale and the semantic differential scale : Compare and contrast the Likert scale and the semantic differential scale. Which scale is the most effective and why? Which scale do we see more often today?
Write the program that asks the user for a color : Write the program that asks the user for a color, a line width, a line length and a shape.
Benefits of the cloud to businesses : Describe cloud computing and the benefits of the cloud to businesses. Describe Iaas, Paas, and Saas. What are the differences between the three.
What role to you as an early child hood educator have : What are the benefits of quality child care on a child's development? In what ways does the Microsystems influence quality child care?

Reviews

Write a Review

Accounting Basics Questions & Answers

  How much control does fed have over this longer real rate

Hubbard argues that the Fed can control the Fed funds rate, but the interest rate that is important for the economy is a longer-term real rate of interest.   How much control does the Fed have over this longer real rate?

  Coures:- fundamental accounting principles

Coures:- Fundamental Accounting Principles: - Explain the goals and uses of special journals.

  Accounting problems

Accounting problems,  Draw a detailed timeline incorporating the dividends, calculate    the exact Payback Period  b)   the discounted Payback Period. the IRR,  the NPV, the Profitability Index.

  Theory of interest - term structure of interest rates

Term Structure of Interest Rates

  Write a report on internal controls

Write a report on Internal Controls

  Prepare the bank reconciliation for company

Prepare the bank reconciliation for company.

  Cost-benefit analysis

Create a cost-benefit analysis to evaluate the project

  Theory of interest

Theory of Interest: NPV, IRR, Nominal and Real, Amortization, Sinking Fund, TWRR, DWRR

  Liquidity and profitability

Distinguish between liquidity and profitability.

  What is the expected risk premium on the portfolio

Your Corp, Inc. has a corporate tax rate of 35%. Please calculate their after tax cost of debt expressed as a percentage. Your Corp, Inc. has several outstanding bond issues all of which require semiannual interest payments.

  Simple interest and compound interest

Simple Interest, Compound interest, discount rate, force of interest, AV, PV

  Capm and venture capital

CAPM and Venture Capital

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!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd