Question

In: Finance

Using IOS Debt Break and/or Android’s similar application or Excel find out the following:       Total...

Using IOS Debt Break and/or Android’s similar application or Excel find out the following:
      Total Interest $
      Total Payment $
      Date when the loan is fully paid, month/year
      Number of months needed to have the loan fully paid, count
Use the following data:
      Name of the debt: ROMI
      Starting balance: $5000
      Remaining balance: $5000
      Interest Rate: 5%
      Montlhy payment: $200
      First Payment: Apr. 20, 2020

Solutions

Expert Solution

Total Interest $ 267.9267

Total Payment $ 5267.9267

Date when the loan is fully paid, month/year - June 2022

Number of months needed to have the loan fully paid, count - 27


Related Solutions

Create any IOS mobile application using swift that can do the following A user should be...
Create any IOS mobile application using swift that can do the following A user should be able to see all uncompleted tasks in a UITableView • A user should be able to create new tasks • A user should be able to edit a task • A user should be able to mark a task as complete • A user should be able to see all completed tasks in a UITableView • A user should be able to close and...
Please find the following ratio for Southwest Airlines Debt ratio = total debt/total assets Indicates what...
Please find the following ratio for Southwest Airlines Debt ratio = total debt/total assets Indicates what percentage of an organizations assets are financed by debt
find the mean using excel 1,2,3,11,22,33
find the mean using excel 1,2,3,11,22,33
Solve using excel: A. Given the following information, calculate the debt coverage ratio of this commercial...
Solve using excel: A. Given the following information, calculate the debt coverage ratio of this commercial loan. Estimated net operating income (NOI) in the first year: $150,000, Debt service in the first year: $100,000, Loan amount: $1,000,000, Purchase price: $1,300,000 B. Given the following information, calculate the loan-to-value ratio of this commercial loan. Estimated net operating income in the first year: $150,000, Debt service in the first year: $100,000, Loan amount: $1,000,000, Purchase price: $1,300,000 C. Given the following information,...
Please display the mathCAD calculations using MATHCAD. Solve the following using the MATHCAD application: (a) Find...
Please display the mathCAD calculations using MATHCAD. Solve the following using the MATHCAD application: (a) Find NC, NV and ni for intrinsic Cubic GaN at (i) 400 K, (ii) 200 K, and (iii) 50 K. (b) Find NC, NV and ni for intrinsic for 3C SiC at (i) 400 K, (ii) 200 K, and (iii) 50 K.
1. Find the maximum of the following total revenue function (TR) by finding out (a) the...
1. Find the maximum of the following total revenue function (TR) by finding out (a) the output ?∗ value where the first order condition is satisfied; and (b) the maximum total revenue. ??(?)=32?−?2 2. Find the maximum of the following profit function by finding out (a) the output ?∗ value where the first order condition is satisfied; and (b) the maximum profit. ?(?)=−?33−5?2+2000?−326. 3. Find the minimum of the average cost function given following total cost function by finding out...
Kindly solve using Excel Given the following information: Percent of capital structure:    Debt 30 %...
Kindly solve using Excel Given the following information: Percent of capital structure:    Debt 30 % Preferred stock 15 Common equity 55    Additional information:   Bond coupon rate 13% Bond yield to maturity 11% Dividend, expected common $ 3.00 Dividend, preferred $ 10.00 Price, common $ 50.00 Price, preferred $ 98.00 Flotation cost, preferred $ 5.50 Growth rate 8% Corporate tax rate 30% Calculate the Hamilton Corp.'s weighted cost of each source of capital and the weighted average cost of...
1. Find the correct excel formula to find the total in a retirment account: Monthly Amount...
1. Find the correct excel formula to find the total in a retirment account: Monthly Amount = $1250 Interest Rate = 2.0% Years in Account = 12.3 2. How much interest did you gain if you invested in a retirement plan with a rate of 2.5% over 42 years? Your monthly deposits totaled $520.
What is Mirr? how do you find it using excel without using excel formula? Below is...
What is Mirr? how do you find it using excel without using excel formula? Below is cash flow. I found IRR is 15.59% and required return is 12% CF Y0 Y1 Y2 Y3 Y4 Y5 Y6 Capital spen $ (30,000,000.00) $ 15,062,400.00 Opp cost $   (5,000,000.00) NWC $   (1,120,000.00) $      (150,000.00) $      (170,000.00) $      140,000.00 $   1,300,000.00 OCF $     9,015,600.00 $ 11,392,500.00 $ 12,193,200.00 $ 10,435,800.00 $ (2,640,000.00) $   (3,960,000.00) CF $ (36,120,000.00) $     8,865,600.00 $ 11,222,500.00 $ 12,333,200.00 $...
Please use Excel for calculations: Find out the maximum stress and out unconfined compression strength and...
Please use Excel for calculations: Find out the maximum stress and out unconfined compression strength and cohesion of soil then Draw Mohr Circle (Use graph and drawing compass NOT FREE HAND DRAWING) Diameter= 7.29 cm Height of Sample= 14.78 cm Deformation Dial: 1 unit = 0.10mm; Proving Ring No: 24691; Load Dial: 1 unit = 0.3154 lb Deformation Dial Reading Load Dial Reading 0 0 20 4 40 9 60 12 80 19 100 21 120 24 140 26 160...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT