Reference no: EM131314541
Please provide the calculations in MS Excel for the future value of an annuity due amount for an $8,000 payment annually in 8 years at 8% compounded on an annual basis to the nearest penny.
Calculate the interest rate to the nearest basis point (0.0001) for a $40,000 investment with an $80,000 financial goal for 8 years. No payments will be made during the 8 years.
Calculate the number of years needed to earn $80,000 with a $60,000 initial investment earning an 8% annual interest rate. Please round to the fourth decimal place. No payments will be made during the 8 years.
To the nearest basis point, calculate the yield of 18% 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.
Please construct an annual loan amortization table for a loan of $40,000 for 5 years at 6%. 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.
Develop a access database based upon the business scenario
: Develop a Microsoft Access database based upon the following business scenario. Be sure to include tables, fields, keys, relationships, and test data in your database. Your final submission will be a Microsoft Access database.
|
Calculate the firm earnings per share
: Statement of retained earnings Hayes Enterprises began 2015 with a retained earnings balance of $928,000. During 2015, the firm earned $377,000 after taxes. From this amount, preferred stockholders were paid $47,000 in dividends. Prepare a statement ..
|
Obtain an expression that relates the drain diameter d
: Obtain an expression that relates the drain diameter D and the minimum water depth h for which the ball will remain in place.
|
Demonstrates the use of important concepts and technologies
: Develop a multi page website that demonstrates the use of important concepts and technologies addressed in the class. Use of a Master-Detail page using the GridView and Details View controls.
|
Calculate the interest rate to the nearest basis point
: Please provide the calculations in MS Excel for the future value of an annuity due amount for an $8,000 payment annually in 8 years at 8% compounded on an annual basis to the nearest penny. Calculate the interest rate to the nearest basis point (0.00..
|
Which country had largest trade deficit over the last year
: Which country had the largest trade surplus over the last year and during the last month? How does the current account deficit/surplus compare to the overall trade balance? How can you explain the difference?
|
What happens when criminals return to their communities
: Do you think the criminal justice system "works" in the United States? Why or why not? Do you think the news media is obligated to present a balanced picture of the overall crime.Do you think that other institutions such as the family, schools, and ..
|
Calculate the total horizontal load per unit
: Calculate the total horizontal load per unit width and the location of the center of pressure measured from the bottom.
|
Determine the force p just sufficient to keep the gate
: The circular gate ABC has a 1 m radius and is hinged at B. Neglecting atmospheric pressure, determine the force P just sufficient to keep the gate from opening when h = 12 m.
|