Hi all,
I have a series of current investments in columns (fields = InvestmentName, Units, Value).
I then have a series of newly acquired investments in columns (fields = InvestmentName, Units, Value). These may be additions to the current investments or new investments.
I then have a series...
Hello. I am using an investment tracking Excel spreadshee. that is supposed to result in a perfectly balanced journal entry, once all the information from the statement is entered. I am always having a difference. I am also having to add GLs for things like Accrued Interest on Bonds, where the...
Hi,
I have a balance sheet simplified like below.
<tbody>
A
B
C
D
E
F
G
H
Year
Year 1
Year 2
Year 3
Year 4
Year 5
Year 6
Year 7
Cash
44
41
92
225
72
386
362
Cash equivalents
51
0
1
322
40
83
0
Short-term investments
</tbody>
I would like to look for value of...
I have a long list of following cells.
e.g. cell A111: 9.03% XYZ investments Ltd. MD(23/06/2019)
A451: 7.52% ABC industries ltd.MD (12/02/2020)
A600: 8.56% XYZ investments Ltd. MD(45/05/2030)
A750: 7.52% ABC industries ltd.MD (12/02/2025)
and so...
I apologise in advance if this is a confusing post!
At the moment I have a table of different investments in column A and in the columns adjacent I have the percentage allocation to each risk profile. The simplified table below should explain better.
<tbody>
Investment
Low Risk
Cautious...
Welcome to ModelOff 2014 - the 3rd Annual Financial Modeling World Championships. After the success of Alex Gordon (NZ) in 2012 and Hilary Smart (UK) in 2013, we're on the hunt for our newest World Champion! If you are or know someone talented in Excel, spreadsheets, and financial modeling...
actuary
amt training
analyst
banking
bloomberg
cfa
competition
corality
excel
finance
financial modeling
intralinks
investments
kaplan
microsoft
microsoft excel
modelling
online
prizes
s&p capital iq
spreadsheets
world
We have looked at several mortgage software solutions for our company, but none have one essential ability that we need. We are currently running on a manual spreadsheet solution, and are wondering if we can automate certain aspects of it.
We are a financier that lends out money to commercial...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.