Import Soulver 2 or Soulver 3 files by dropping them on the dock icon. Open specific sheets via URLs. Perform quick calculations from a Spotlight like interface. Save your calculations to Soulver as a sheet (⌘S) Access a 'QuickSoulver' from within Soulver, or the menu bar, or global hotkey. Soulver 2.7.0 Multilingual macOS 8 mb. Soulver helps you do quick calculations and work things out. It's quicker to use than a spreadsheet, and smarter and clearer than a traditional calculator. You type out your problems as you would on paper, and Soulver calculates your answer as you type. You can do calculations over multiple lines,. Soulver helps you work things out. It's quicker to use than a spreadsheet, and smarter and clearer than a traditional calculator. Use Soulver to play around with numbers, do 'back of the envelope' quick calculations, and solve day-to-day problems.
When done well, screen design can get quite technical. Grids, guides, gutters and ensuring distributed elements land on whole pixel values becomes complex when there’s many moving parts.
There’s nothing wrong with shuffling and resizing layers around until reaching the desired outcome, but I often get quicker results by breaking out a calculator. And for this kind of work, Soulver is my favourite, because of the way it handles constants and multiline equations (disclaimer: Acqualia have no affiliation with Bjango, I just like their app). It’s a nice mid-point between a physical calculator (remember those?) and a spreadsheet, often trumping both for speed for designer-y calculations.
It’s possible to add custom constants to Soulver. Here’s mine.
Yes, they’re all in iOS points, rather than Retina pixels. phi and gr are the Golden Ratio. iphi and igr are the inverse of the Golden Ratio. With those constants set, it’s possible to create an expression to work out how wide each tab bar button would be on an iPhone, if you wanted four even width buttons.
What if you needed a 10pt margin each side?
What about the same for landscape orientation?
Splitting the iPhone 5’s display into two vertically by the Golden Ratio, but excluding the status bar?
Let’s say you’re working on an iPad design, and you’d like to figure out the width of columns in a two column design with margins, a gutter and you’d also like to see how it translates to portrait and landscape orientation.
The results fall on non-integer values (464.5 and 336.5), which isn’t ideal. What if we tweak the gutter size?
That’s better. You can now choose the rectangle tool in Photoshop, and with a single click on the canvas, type in the exact value you need.
Starry night pro plus 8 0 28. Perfect.
Update: If you’d like to use my Soulver variables, Marc Boquet has done all the work for you, and shared his variables preferences file: Variables.plist on Gist
Published 17 July 2013.
More Videos
Loan amortization schedules. Formulas. Interest and principal portions. Feel overwhelmed yet? Many Americans do when they’re discussing possible loans with bank officials. And why shouldn’t we? After all, finance is not everyone’s strong suit. Unless you have some academic grounding in finance and accounting, you really don’t get the whole picture. Unless someone were to lay it out simply. Let’s discuss loan amortization with a simple example. Imagine if you were in between paychecks or low on funds. You have Xfinity triple play, car payments, mortgage payments, and kids in college. You have a business, wages, expenses and utility bills that can’t wait until the end of the month. So you decide to take out a loan of $100,000 to help with your cash flows. Let’s take this situation further to see how loan amortization works.
How to Calculate Loan Amortization
The loan amortization formula looks fairly confusing at first glance:
This is the standard formula to calculate monthly payments. In the above equation:
- A is the amount of payment for each period.
- P is the principal amount of the loan.
- r is the rate of interest.
- n is the number of periods.
The first thing you need to know is that your monthly payments on your loan are actually two parts. One portion goes back to paying back the principal amount of the loan. The other portion goes towards paying the interest on the loan. As the principal payments portion increases, the interest portion will go lower. You can find lots of amortization calculators on the internet. But it always pays off to know exactly how your loan works. Here’s how to calculate your loan amortization:
- Gather the Information You Need
- Make a Spreadsheet for Convenience
- Calculate Month 1 Payment’s Interest Portion
- Calculate Month 1’s Principal Portion
- Calculate Month 2’s Amortization
- Find Month 2’s Principal Portion
- Calculate Amortization for Entire Loan
Let’s dive right into it and look at each step one by one.
Gather the Information You Need
There are 3 main things you need when calculating amortization. These are the principal amount of the loan, the interest rate, and the loan term. You also need the amount of the monthly payment amount. For the purpose of our example, the loan details are as follows:
- The principal amount outstanding is $100,000. This means in the formula, P = $100,000
- The interest rate is 6% per annum (or yearly). The monthly interest rate r= 6%/12 = 0.005%
- The loan term is 3 years (36 months), so n = 36
When you put these values into the formula, you get the repayment amount
( A = 100,000[ frac{0.005(1.005^{36})}{(1.005^{36})-1}] = $599.55 ) Presentation prompter 5 4 2 – feature filled teleprompter machine.
The actual amount of your payment will stay the same for the duration of the loan. But the principal and interest portions will change. The interest portion is high in the beginning, with a lesser percentage going back toward the principal amount. Now you have everything you need to calculate amortization for the duration of your loan. Let’s move on to the next step.
Make a Spreadsheet for Convenience
When calculating amortization, you need to understand that there are a number of variables. So, to avoid errors and make life easier, it’s best to do this on a spreadsheet. Make the 7 following columns:
- Month
- Opening Principal
- Rate
- Payment
- Interest Payment
- Principal Payment
- Closing Principal
There will be a total of 360 rows in this spreadsheet, one for each month. Sounds frightening? Don’t worry. You’ll only have to do the grunt work for the first 2 months’ calculations. Once you have entered the right equations, all you have to do is drag them down. There is an equation built into Microsoft Excel that can really help you with calculating amortization. Its called the PMT formula and it works when you input:
=PMT(r,n,p) or in our case =PMT(0.005,360,100000). This will give you the value of your amortization payments, which you can drag down the rows to autofill.
You will get a complete schedule of amortization for your loan. Let’s move on to the calculations.
Calculate Month 1 Payment’s Interest Portion
Interest is equal to the principal times rate times loan period. Or I = P*r*t. In our case:
I = 100,000 * 0.005 * 360
The first step is to convert the yearly interest rate into a monthly rate. 6%/12 = 0.005% per month. The next thing to do is to multiply your principal amount with the monthly interest rate. $100,000 x 0.005% = $500. For the first month, $500 out of $599.55 will go toward interest.
Calculate Month 1’s Principal Portion
Calculating the principal portion of the payment for the first month is simple.
Soulver 2 5 3 0
The payment amount A comprises of the principal portion P and the interest portion I.
You need to subtract the interest portion from the loan repayment. In this case, A= I + P which means P = A – I =$599.55 – $500 = $99.55.
As you can see, the major part of your first repayment is towards interest. There is a smaller payment towards the principal outstanding, which will reduce interest in the next month.
Calculate Month 2’s Amortization
Now its time to repeat the process, but with the second month. At the beginning of the second month, we have a lower amount of outstanding principal. $100,000 – $99.55 = $99,900.45. This is the opening principal amount for month 2. Now we calculate the interest portion of the payment in month 2 which is $99,900.45 x 0.005 = $499.50. As you can see the interest portion is lower in month 2 than in month 1.
Soulver 2 5 3d
Find Month 2’s Principal Portion
Calculate the principal portion of the loan repayment in the same way as in month 1. Subtract the interest portion from the last step from the payment amount. $599.55 – $499.50 = $100.05. This amount is larger than the principal amount for the first month ($99.55).
Calculate Amortization for Entire Loan
Soulver 2 5 3 X 4
This is where the spreadsheet will come in handy. Otherwise, you’d have to repeat the process manually for all 360 months. All you have to do is drag down the equations you used for the calculation in the first 2 months. The opening principal and the closing principal gets reduced with each payment period. By the end of the loan term, the interest portion declines to zero. The principal amount outstanding at the end of the 360th month should be zero.
Knowing how amortization works can come in handy with most financial decisions you take in your life. If you manage your finances well, you won’t have to haggle or argue with your bank. Just keep an eye on the elements of the loan we discussed above. Hopefully, you’re now in a better position to calculate your loan amortization for the entire term. Let us know if you found this article to be helpful.
Related posts:
Advertisement