+ Reply to Thread
Results 1 to 2 of 2

'How to calculate "Monthly Repayment"‏

  1. #1
    Registered User
    Join Date
    09-08-2013
    Location
    Singapore
    MS-Off Ver
    Excel 2007
    Posts
    14

    'How to calculate "Monthly Repayment"‏

    How to calculate the monthly repayment based for each and every asset type (highlighted in yellow ? The age of asset is based on months. And the Interest Rate and Term of Loan (months) data is highlighted in yellow.
    Attached is the excel file.

    Thanx
    Attached Files Attached Files

  2. #2
    Forum Expert dredwolf's Avatar
    Join Date
    10-27-2012
    Location
    Clearwater,Canada
    MS-Off Ver
    Excel 2007
    Posts
    2,649

    Re: 'How to calculate "Monthly Repayment"‏

    This looks like a homework assignment, and the answer is in the note...I may be wrong here, but it seems to me that if you used the built in help of excel you could figure this out for yourself...., especially for a homework assignment
    If you get something close, and need to figure out WHY it doesn't work, I'll be happy to help then
    A picture may be worth a thousand words, BUT, a sample Workbook is worth a thousand screenshots!
    -Add a File - click advanced (next to quick post), scroll to manage attachments, click, select add files, click select files, select file, click upload, when file shows up at bottom left, click done (bottom right), click submit
    -To mark thread Solved- go top of thread,click Thread Tools,click Mark as Solved
    If you received helpful response, please remember to hit the * of that post

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How to calculate "Age of Asset" & "Monthly Repayment"‏
    By yjohari in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-30-2013, 07:27 AM
  2. [SOLVED] How to USE """"" cells count """"" change font color
    By austin123456 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-09-2013, 06:14 AM
  3. [SOLVED] Need Macro to compile data from "Weekly" sheets and sum up into "Monthly" summary sheet
    By mo4391 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-21-2013, 07:25 PM
  4. Replies: 1
    Last Post: 10-22-2012, 09:38 AM
  5. Replies: 5
    Last Post: 10-12-2010, 06:46 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1