Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Hi, what formulas do I use for Owe, Interest, and prin Pay? (This is for 49 years***) Please explain, and thank you! AutoSave OH -
Hi, what formulas do I use for Owe, Interest, and prin Pay? (This is for 49 years***) Please explain, and thank you!
AutoSave OH - Q Loan 23716827 - Enid (Yuki Zheng - File Home Insert Page Layout Formulas Data Review View Help Calibri 11 E General A A A- Wrap Text Merge & Center BIU - $ % 8- Conditional Format as Cell Formatting Table Styles Styles Clipboard F Font Alignment Number D10 X fa Installment Loan = Equal Payments 2 Date of Loan 3 Borrow 4 Years 5 Rate 6 Payment 1/1/2020 $504,000 49 13.80% ($69,675.63) Interest Total Pay Prin Pay Cash Flow 0$ 1 $ 504,000 UwN Owe 504,000 (69,676) (69,676) (69,676) (69,676) (69,676) (69,676) (69,676) (69,676) (69,676) (69,676) (69,676) (69,676) (69,676) 160 6761 7 $ 69,676 69,676 69,676 69,676 69,676 69,676 69,676 69,676 69,676 69,676 69,676 69,676 69,676 60 676 8 $ 9 $ 10 $ 11 $ 12 s 13 $ 14 LoanStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started