Answered step by step
Verified Expert Solution
Link Copied!

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 -

image text in transcribed

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 Loan

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

DCAA Contract Audit Manual Volume 1

Authors: Defense Contract Audit Agency

1st Edition

B08HTL19V5, 979-8684992995

More Books

Students also viewed these Accounting questions