(4) FIN302_Excel with answers_Loans and amortization table_Feb5 (3)

Business Math Worksheet 8.2: Installment loans-Amount Financed Name Background: An installment loan is repaid in several equal payments over a specified period of time. Usually, you make a down payment to cover a portion of the cash price of the item. The amount you finance is the portion of the cash price that you owe after making the down payment. Amount Financed = Cash Price - Down Payment Down Payment = Cash Price x Percent 1. Flora Quinton is buying a new air compressor for her auto repair shop. It sells for $1,299. She makes a down payment of $199 and finances the remainder. How much does she finance? 2. Beatriz Ruiz is buying new office furniture. It sells for a cash price of $2,358.60. The down payment is $200.00. What is the amount financed 3. An office remodeling project costs $15,880. If you pay $3,680 towards the project, how much do you finance?

Pls choose right answers no need explanation

Fast pls solve this question correctly in 5 min pls I will give u like for sure Surbh

Part AUsing the following free cash flows and cost of equity = 7%, discount FCF year 1 back to time 0 (today).  FCF year 1 = 500; FCF year 2 = 520; FCF year 3 = 560; FCF year 4 = 590; FCF year 5 = 610 a) 429.36 b) 467.29 c) 512.85 d) 422.10Part B Using the following expected interest payments, cost of debt = 5%, and tax-rate = 21%, discount the year 4 expected payment back to time 0 (today).  Expected interest year 1 = 50; year 2 = 35; year 3 = 20; year 4 = 10;  5 = 0   a) 9.31 b) 10.11 c) 13.65 d) 6.50

Need help with 4,5,6.

Note: Hand written solution is not accepted.

Fisher Equation: Nominal, Real, and Inflation = 10%. Expected inflation is E(T) = Q1) You lend money to a business colleague at a rate of i 3.5%. What is your real rate of return r? Use the exact Fisher Equation. = Q2) How much would you charge a colleague on a loan of $100 if you want your real rate or return to be r = 6% and the expected inflation is E(л) = 4%. E.g., what is the nominal rate i? Use the exact Fisher Equation. Q3) A corporate bond pays investors both a fixed and variable rate of return. The fixed rate is constitutes the real return which is r = 4.5%. The variable rate is indexed to the CPI and is to compensate investors for inflation. If the expected inflation in the next year is E(T) = 2.5%, what is the nominal rate of return i the company will have to pay? Enter your answer in the table below in the cells colored in yellow. You must show all work to receive credit. Q1) r= |Q2) i= ||Q3) i= Answer

Fast pls solve this question correctly in 5 min pls I will give u like for sure Surbh

Suppose you are offered $7,100 today but must make the following payments: 1 2 Cash Flows ($) O $7,100 1-3,800 2-2,500 3 -1,600 4 -1,400 Year 4 6. 7 9. 10 11 What is the IRR of this offer? (Do not round intermediate calculations. Enter your ans 12 a. 13 14 15 16 17 b. If the appropriate discount rate is 10 percent, should you accept this offer? 18 19 multiple choice 1 20 21 Reject Ассept 22 23 24 25 C. If the appropriate discount rate is 19 percent, should you accept this offer? 26 27 multiple choice 2 28 29 Аcсept Reject 30 31 32 33 What is the NPV of the offer if the appropriate discount rate is 10 percent? (A negative ar What is the NPV of the offer if the appropriate discount rate is 19 percent? (A negative ar 34 d-1. 35 d-2. 36

I need help with this problem question

Fast pls solve this question correctly in 5 min pls I will give u like for sure Surbh You are considering the following fixed interest rate mortgage loan alternatives: Alternative 1: $180,000 initial loan balance 4.00% annual nominal interest rate 30-year amortization schedule $859.35 monthly loan payment Alternative 2: $195,000 initial loan balance 4.25% annual nominal interest rate 30-year amortization schedule $959.28 What is incremental cost of borrowing the additional $15,000? 0.58% 4.25% 5.8% Correct! 7.01%?

mni.4

Question E5-2

f5

Hi, can someone help me with these excel problems?

► CRC Inc. is buying new equipment that has the following cash flows: Year Cash Flow O-$17.7 What is the NPV if the interest rate is $6%? O $482.24 D -$537.78 0 -$500 O $22.44 1 $100 2 $200 3 $250

Please help with questions

Suppose that you have two loan choices with monthly payments Choice Loan Amount Term (years) Interest Rate 1 $ 250,000 30 5% 2 $ 220,000 30 4.50% (a) What is the incremental borrowing cost of $30,000 for loan 1 over loan 2 if you hold the loan for the entire term and there are no origination costs for the two loans? Incremental Borrowing Cost: $3,254.72 (b) What is the incremental borrowing cost of $30,000 for loan 1 over loan 2 if you hold the loan for only 6 years (72 months) and there are no origination costs for the two loans? Incremental Borrowing Cost: $650.94

Please solve max please in 15-22 minutes and no reject thank u. Im needed please no reject

Solve this financial accounting problem without use Ai

your assumption and write it on the submitted file. [example: sa interest rate or years are not mentioned. you assume any value, do your problem, write your assumptions/answer on work paper. Question 1 You have $2,000 to invest, the MARR would be at least what you need pay for borrowing $2000 True OFalse MacBook Pro F6 F4 FS F2 F3 %23 24 % 2 3 4 5

A B C D E F G H 1 You are interested in purchasing a $17,999 new car. You are weighing your 2 options regarding down payment and payment schedule. Your credit score 3 indicates that you can secure a loan with a 5.9% interest rate for a 5-year loan. The facts are summarized below. Car Price Down Payment 4 5 $ 6 7 Annual Interest Rate: 8 Loan years 9 17,999 10% 5.90% 5 10 Answer the questions below. 11 12 1. If you pay 10% as a down payment (so only need to borrow 90% of the car 13 price), use an EXCEL formulas and functions to complete the following table 14 assuming you make ANNUAL payments. Payment amount: 15 16 17 18 Total interest: Total repayment: Format with $, and as a positive number # of payments X Payment amount Total repayments - amount borrowed 19 20 21 2. If you pay 10% as a down payment (so only need to borrow 90% of the car 22 price), use an EXCEL formulas and functions to complete the following table 23 assuming you make MONTHLY payments. 24 25 Payment amount: 26 Total…