Application Time! 1) You will type the TVM inputs in the table provided from the "Info Sheet". 2) Mirror the inputs from the "Info Sheet" to the TVM cells provided. 3) Within the TVM cells, if needed, compound 4) In the "ANSWER" cell show us your TVM calculation Goal 1: Opened an account with $1500, with the hope to have a total of $2500 saved in an LG2-Q8 emergency fund within one year (no additional payments). What would the quarterly interest rate be needed to reach this goal? Goal 2: A credit card balance of $2000 with an 15% rate. The goal is to pay off the credit card LG2-09 by the end of the year. (future is a $0 balance) Compounding Number (select from dropdown) How many months will it take to complete this goal? Compounding Number (select from dropdown) 12 What would be the monthly payment to reach this goal? Goal 3: Student loan balance of $18,000 at 6.5% and making $425 monthly payments. (future Compounding Number LG2-Q10 is a 50 balance) (select from dropdown) 12 Note: RATE=%/Compounding # 3.5% 5.74% RATE RATE RATE Note NPER Compounding 5 4 NPER NPER NPER 0 0 PMT PMT PMT PV $6,000.00 PV $3,200.00 PV S FV 7,126.12 FV $4,000.00 FV ANSWER #N/A ANSWER #N/A ANSWER #N/A

How much would you invest today in order to receive $30,000 in each of the following? (for further instructions on present value in Excel, see the Suggested Resources in the textbook: https://cnx.org/contents/kg0cimBs@14.13:bDQCmuJO@6/Suggested-Resources) a.  10 years at 9% b. 8 years at 12% c. 14 years at 15% d. 19 years at 18%

Hi There! I solved the problem, but can you correct my written formula to get a total of $90,691.36 please, the answer I got is italicized and underlined below. Please also answer the questions, and put everything on an excel spreadsheet and show the formulas please for all of the questions below. Thank You!  You are offered the opportunity to put some money away for retirement. You will receive 10 annual payments of $5,000 each beginning in 26 years. If you desire an annual interest rate of 12% compounded monthly, answer the following two questions:   How much would you be willing to invest today? How much would the money (that you will be willing to invest today) be worth at the end of your last payment (i.e., in year 35)? Amount that you would be willing to invest today = PV = $5,000/(1.01)26*12 + $5,000/(1.101)27*12 + $5,000/(1.01)28*12 + $5,000/(1.01)29*12 + $5,000/(1.01)30*12 + $5,000/(1.01)31*12 + $5,000/(1.01)32*12 + $5,000/(1.01)33*12 + $5,000/(1.01)34*12 +…

You are an angel investor, and 4 entrepreneurs have approached you to build some innovative folding tables, and the proposals are as follows. Project A, an investment of 566967 and annual cash flows respectively of 415527, 209635, 199906 and 298311. Project B, an investment of 439043 and annual cash flows respectively of 417004, 150449, 117975 and 384645. Project C, an investment of 628001 and annual cash flows respectively of 140108, 507720, 225467 and 147962. Project D, an investment of 450834 and annual cash flows respectively of 102735, 111878, 508753 and 154070. If the rate expected by you is 21.33% per year of compound interest. Which project is more profitable according to the NPV (Net Present Value)?Question 1 options: d c a b

Subject -account  Please help me.  Thankyou.

If you receive a grant for a $135,000 project and the grant has a 2:1 match. How much grant money would you receive?

How to solve a problem when they give you the liability amount $120000 and the equity $232k and they ask to fund the total assets?

Please complete this practice problem by using the 2 images below. Please write cleary and everything in order. Thank you

Excel Skills 7. Solve the follow sections: a. Complete the following spreadsheet, showing how much will be in your bank account if you deposit an initial deposit (cell B2) today and it draws annual interest given in cell B1. Interest 2 Initial deposit 3 4 5 6 7 A 8 9 10 Year " 0 1 23 4 5 B b. Graph the results of the bank account. 8% $155 In bank account.

Subject - account  Please help me.  Thankyou.