# Loan Formular To Capture Overdraft Bank Facility

Aug 30, 2009

how I can solve the issue of creating a spreadsheet (similar to an amortization one) that could deal with unequal re-payment regime as well as unfixed (anytime of the month) payment periods.

## Game Points Bank Account (running Total For The Bank)

Nov 5, 2009

Sheet6

80You Need 18,000 Pts.IntermediateYour Credit is 0 Pts

Excel tables to the web >> Excel Jeanie HTML 4

i have a "Game Points Bank Account" that keeps track of the points users earn or spend in the game...what i need help is creating a running total for the bank..ive tried everything nothing works..

(this is actually like a traditional bank account)

each player starts with 10,000 points

*Row 8 is the only row to have formulas*

*Rows 9-11 are typed in to show my desired results*

Here is the point value "Ranking System" for Column T

Sheet6

Excel tables to the web >> Excel Jeanie HTML 4

## Iteration Inconsistency: Allow For A Cost Being Added To Loan Amount Where The Cost Is Based On The Total Loan Amount

Mar 15, 2007

In a financial environment we have a calculator which uses iteration to allow for a cost being added to loan amount where the cost is based on the total loan amount. Iteration is set to 100 iterations with max change .001

On one PC the first time the calculator is opened it gives a particular (incorrect) result. If the input cells are cleared and the data re-entered, it gives the correct result. This only happens on one particular PC. Is there some other setting , other than the iteration setting, that would cause this?

## Formular For Pythagoras

Nov 30, 2009

how do i write the formular of pythagoras, I input a1^+a2^=c^ excel informs of an error I have also tried a1+a2^'c still errors can any body give me advice to what would seem such a simple input or am i misssining something here

## Formular To Produce A Negative Result

Feb 20, 2007

If I put a formular in cell A2 "A1*.10" how can I get the result to come back negative if there are no negative numbers involved?

## Disable Print Facility

Sep 14, 2004

I have a spreadsheet with a print button which allows the user to print only the parts I want them to see. I have removed the Printer icon on the toolbar, but does anyone know how to remove the Print option on the File menu? (File/Print)

## Facility To Execute Macro

Oct 29, 2006

Is is possible to have a button or a box of some sort that the user of a spreadsheet can click to execute a piece of vba code that I have? If so, can someone tell me how to insert such a button?

## Sheet Has Lost The 'UNDO' Facility

Jun 23, 2009

I have created a spreadsheet in the field of marine surveying. In that sheet, I have used a lot of macros (21 modules) and a lot of VBA, most of it provided by kind people on this forum. But what has happened now, is that when I use that particular worksheet, the 'Undo' menu item in the 'Edit' menu has become permanently grayed out and it says 'Can't Undo'.

In other words, I cannot undo, even if I have made the wrong entry in an unprotected cell. If I use any other sheet, or make a new sheet, everything returns to normal. So, is there any way I can re-gain the 'Undo' facility, while using that particular sheet. I am using Excel 2003 on a Windows XP Home (SP3) platform.

## How Do I Disable The Right Mouse Cut And Paste Facility

Sep 23, 2006

I need to be able to prevent any user from cutting and pasting data in one of my spreadsheets. I have protected it all, removed cut and paste from the options- edit tab, but you can still cut and paste with the right mouse shortcut key.

How do I stop this from being available?

## On Click Method To Open The Find Facility

Nov 9, 2008

I was wondering if possible i could use an on_click method to open the find facility in excel. I know it may be easier to use the Edit, Find or Ctrl+F way.

But i have people using excel with no past experience what so ever, and i would like to make it as easy as possible....i.e a click of a button that says "Search".

## Create Search Facility That Will Run On Variable Functions And Display Information On Screen

Dec 23, 2013

I have an excel file with a large amount of employee data in it and want to create a search facility that will run on variable search functions and display the information on the screen

I want to be able to enter variable search functions as follows:

Employee Number; shows all information on employee
Division: shows all employees in division (possible from a list of all divisions)
Appraisal Eligibility : Applicable shows all the applicable employees
Job Role: shows all the employees with the same job role (possibly from a drop-list of all roles)

I know its easier in Access, but all records in Excel as a legacy and don't have time to create an access database currently.

## Loan Balance

Nov 30, 2009

I owe 15462 in the bank, currency dont matter here, that is what I owe right now, but I want to have a cell in the frontpage with the amount left, so can I make a line called =remaining-each month

the amount should then each month be substracted from the new month and so on, until the amount is 0

can this be done?

the second page in the spreadsheet has a post with monthly pays to the bank ...

## Finding Which Stage The Loan Is In?

Oct 3, 2013

1. Want to findout in which stage the loan is ? Eg: 1212321231 is in PROCESSING STAGE because the date appears under processing .

2. want to find out how many stages it has paased ? Eg: Loan 1212321231 has passed 3 stages and now in 4th stage(processing).

## Can't Copy Bank Statement

Oct 12, 2013

So I want to copy my bank statement into excel, but when I do, rather than separating each line into a row of separate cells, it separate it into a column of separate cells. and it does this for each row in the same column.

So:
A1 is in the right spot
A2 should be B1
A3 should be C1
A4 should be A2
A5 should be B2
A6 should be C2
etc....

Any way I can sort this out at the touch of a button? (or a few buttons)

## UK Bank Holiday Calculator

May 2, 2006

I found a link to a website on one of the forum pages. I had a look in the website and it showed a formula for calculating when Easter falls - I didn't know it could be worked out, but it can!!

I therefore decided to investigate further. I picked up another formula to calculate the first MOnday in May and I have now put together a little spreadsheet that will calculate all bank holidays in the year entered in cell B1. It also takes into account additional bank holidays that exist when Christmas Day and/or Boxing Day fall on a weekend.

## Bank Interest Calculator

Dec 1, 2006

I'm an amateur to macro as I'm only in a low level class at a university... But I'm attempting to make a macro for a bank interest calculator. It asks your type of account(which then assigns an interest rate to it), how much money is in the account, and also how long th emoney will be in the account. I used a "Select Case" for the account types, but I seem to be struggling for it to work, it won't put the value of the total into the assigned cell, or it's just not computing it(as I get "0" each time I run it)...

Public Function BankCalculator()
'Bank Calculator for different accounts
'declare variable
Dim shtBank As Workbook, strAct As String, intMon As Integer, strLong As Integer, intTotal As Double
Set shtBank = Application.Workbooks("Bank Calculator.xls")
'input box for amount of money, assign address
intMon = InputBox(prompt:="How much money do you currently have in the account?", _ ......................................

## Loan Amortization Calculations

Sep 27, 2007

I'm working with a loan amortization worksheet (downloaded from Office Online). Unless I don't understand correctly, the date formula on the worksheet doesn't calculate the way I need it to. I'm not totally sure what the formula they use is doing. It does use a lot of named ranges.

If a user inserts the total "Number of Payments per year", then I want the date to return the proper payment date.

For instance, If the start date is 1/1/07 and the number of payments per year is 24 then the payment dates should be like

1/15/07
1/31/01
2/15/07
2/28/07

It should be the 15th and the last day of the month.

If I put 52 as the number of payments then I want the formula to set the payment dates to every Friday.

I'm still learning formulas so bare with me guys. Attached is the worksheet.

## Keep Track Of Bank Transaction In Budget - In And Out

Mar 19, 2014

Solution to keep track of bank transaction in a budget - both in and out

With:

=SUMPRODUCT(--(Table[[CAT]:[CAT]]=\$C5);--(Month(Table[[DATE]:[DATE]])=G\$3);--(Table[[IN]:[IN]]))

Table1:
DATE | CAT | IN | OUT
----------------------

The transaction CATegory and Date place the amount from table - column IN to the corresponding cell in my budget.
I would like my bank account to reflect both income an expenses from 2 columns in Table: IN and OUT

Workbook example: [URL] ...........

## Multiple Loan Repayment Optimization

Apr 19, 2006

I have 4 Loans of various interest rates, balances, and minimum payments.

Assuming I have a certain amount of money to pay out each month, how can I minimize the total amount I pay over the lifetime of the loans?

Given:
Total Monthly payment: M
Interest Rate for each loan: R1, R2, R3, R4
Initial Principal for each Loan: P1, P2, P3, P4
Minimum Monthly Payment: Min1, Min2, Min3, Min4

Each month, how should I distribute M over the 4 loans?

## Calculate Home Loan Repayments

Jan 8, 2007

I have used the PMT function but this gives me the total to pay per month.
I want to know what the repayments would be and also allow me to add in each one of the periods and extra repayment option.
So if in the year I wanted to pay an extra \$100 per month, I would put \$100 next to each period as in a particular period(s) I might not have to put in there but want to predict what the amount owing on the house is.
Is this possible or is this too complicated.

## Insert Bank Rows After Each Occurences

Sep 22, 2007

I want to insert two blank after each broker. I am copying each broker's information to another spreadsheet. each broker information may take several rows...after copy one broker information, I want to automatically insert two blank rows...how can I do that in VBA excel?

## Is Loan Amortization Affected By The Currency

Feb 20, 2008

There are various references and links to " mortgage calculators;" though they are specific to the US dollar. Is the formula still the same, irrespective of the currency and why does it come across as quite a complex calculation? i have been taksed with designing a "calculator" and don't seem to know where to start as the currency issue is confusing me.

## Accessing Bank Balances Automatically With Excel?

May 31, 2014

Is it possible to have my Excel cash flow sheet access my bank checking account and automatically update with my current balance?

## Loan Payment And Make Installment List

Nov 29, 2013

I have a file which student Monthly Loan Payment schedule.

I want to make a list which shows all payment period by installments and payment amount , dates by Student names.

Attached file, you can see all detail and wanted LIST.

## Temporarily Hide Transactions In Bank Statement?

Feb 3, 2014

I have downloaded some of my bank statements in excel format but they are just static data - ie, they are just numbers in boxes and the BALANCE column does not react when I take out a transaction.

I have put in a formula for the BALANCE column so it does now take its value from the previous day plus or minus transactions, but now I want to do additional things.

- How would I, for example, categorise several transactions as "HOLIDAY" [URL] ....... and then temporarily make them disappear so that I can see the effect of that on my balance? I can see how to hide/unhide transactions but that doesn't actually seem to have any impact on the balance column.

- Second query: how do I make my current spreadsheet a template so that when I download the next bunch of bank statements I can just apply all the formulae in this one to it?

## Bank Transactions - Grouping / Totaling Like Titles

Jun 1, 2014

I'm trying to group a year's worth of bank transactions. The initial data that was cut from pdf files is a date, payee and amount

1) how can I search down col A and give the sum of all like Payees, then total each set of similar payees? Maybe if first 6 characters match, then total until it comes to a different set.
Total each set.

2) then, I need to assign a category to each set of payees, so if contains usps, then add category "postage"

3) formula to find all postage totals and combine for a grand total per category.

usps15.23postage
usps14.32postage
usps5.23postage
fedex5.25postage
fedex10.22postage
shell45.28fuel
shell99.38fuel
qt27.38fuel
qt44.88fuel

## How To Calculate Interest Rate For Loan Product

Jan 31, 2014

I currently use goal seek to calculate an interest rate for a loan product. My problem is i would like to have the same function but not through a goal seek. In goal seek i have to set the value i want to achieve but ideally i want it to calculate automatically

I have attached a workbook with details. I use a loan amortization schedule to calculate the interest from parameters set on sheet 1

## Effective Rate Calculation, Interest Only Loan

Aug 27, 2008

I have a calculation I do that calculates a clients "effective interest rate" if they make extra payments towards principal.. Calculation works fine.. However, I am now trying to figure out how to amend that code if it's an interest only loan, anyone have any ideas?

Here is the effective rate calcs on a random normal amortization loan:

this is in B2, and answer is 7%
=RATE(B4*B5,-((B3+B7)/B6),B7)*12

B3 = Total*Interest 279017.8
B4 = #*Years*in*Loan 30
B5 = #*Payments*/*Year 12
B6 = Total*Payments 360
B7 = Beginning*Principal 200000
B8 - Ending*Balance 0
problem is when someone is on an interest only loan they pay more interest than a normal amortization because they are not reducing the principal in the first x number of years. So I need to compare the interest only effective rate to an interest only loan.

Here is the example I'm working on... A client's loan is the following:
Loan amount - 131,538
interest rate - 6.15
30 year amortization
10 years interest only

normal client would pay an interest only payment of 674.13, then after i/o period would go to 953.80 for last 20 years of the loan, and they'd pay about \$178k in interest.. Now if that client pays an extra 1,000 per year, I can calculate the amount of interest they'd accrue, but have no clue how to back into the "effective interest rate", basically that says you are paying the same amount of interest as someone with a x.xx% interest only loan.

## Autofill Dates Excluding Bank Holidays & Weekends?

Feb 26, 2014

Is there a way to autofill dates in excel to exclude weekends and bank holidays?

## Table To Calculate Interest With Variable Withdrawals For Loan

Aug 2, 2014

I have been loaning my brother money over the past 14 months. The loans have been in the form or \$1000 per month plus random payments for one-off expenses like doctors fees. He's not paid anything back yet but we want to know what the total owed is for interest of 10% per annum.

I can easily create a table with payments I've made and the dates with a running total of how much I've paid but how to I create a running balance of what he owes over time based on adding in interest. This might end with a one-off payment in a couple of months, I'd like to calculate what is owed there as a minimum.