X = sell price

B = buy price

I = investment in $

D = desired profit in $

S = number of shares

I am wanting to write a program to ask the following questions and return an answer like so:

1. What is the buy price?

2. How much do you want to invest?

3. What is the desired profit?

Ans: Your sell price is X

So as you can see, if there is more than one calculation required (which I suspect is the case), then that is fine. I have figured out how to do this as a percent of profit, but I want to keep it simple by stating desired profit in $ amt.

Thanks ]]>

X = sell price

B = buy price

A = amt invested in $

D = desired profit in $

S = Number of shares

I would like the formula to calculate variables X and S based on B, A and D. This will be a useful calculation for determing what I need to sell a stock at based on the known variables.

I want to write in a python program so if it can be broken down into multiple calculations that would be better.

Question/answer format would be such:

1. What is the buy price? I.e. $2

2. How much do you want to invest? $500

3. How much profit in $ do you want to make? $200

Your sell price for this amount is x

I can work it out based on percentages, but I prefer to use $ amt variables.

Cheers ]]>

Can anyone provide me some problems with solutions for following topics:

Compound interest

Amount & present value

Nominal & Effective Rates

Annuity due and ordinary deferred annuity

needed for my final exam revision ]]>

Solution: $8,000/(80% * $15,000) * $7,500 = $5,000

What is the reasoning for the above calculation: (amount insured)/(80% * value of house) * (loss by fire ) = amount paid by the insurance company?

Why not something like (loss by fire $7,500 ) / (80% * value of house, $15,000) * amount insured, $8,000?

I am trying to understand the reasoning for using the correct calculation. ]]>

Can anyone help me with the solution of those 2 problems for my final exam revision

1) A loan of $8,000 is to be repaid with quarterly payments for two years with an interest rate of 4%

compounded quarterly. Find the quarterly payment and construct an amortization schedule

Given:

Solution:

a.

b.

c.

Amortization Schedule

2) ADG Company issues $1,000,000 worth of bonds to raise capital to improve its company’s facilities.

What semi-annual deposits must be made into a sinking fund earning interest at 8% compounded semi-

annually to redeem the bonds at the end of 15 years? Construct a sinking fund schedule for the first 2

years.

Given:

Solution:

a.

b.

c.

Sinking Fund Schedule ]]>

The Bondy family wishes to set up a scholarship fund. They would like to see 2000/year awarded over a 20 year period. It is expected that an investment could likely earn an average of 7.5% interest. How much must be invested now so that these awards can be granted? Show the TVM solver values.

---

N = 20I% = 7.5PV = 10972.46PMT = -2000FV = 40,000P/Y = 1C/Y = 1

If it were compounded annually, would I be correct?

]]>If it were compounded annually, would I be correct?

im hoping someone can help me as math is far from my strong point. Please excuse me if this post isnt to protocol but i’ll try my best to explain the problem Im trying to solve.

I want to set some fair targets for a team of sales people , without using the ‘gut feeling’ approach.

Heres the background:

we have 6 sales people between whom an increase in a global target for 2019 financial year needs to be shared. The overall increase is £2m.

The total sales target for this team 2019 is £9m, it was £7m in 2018.

The overal global increase can of course be represented by a percentage (28.57%), and last year the SUM of the 6 sales peoples individual targets was equal to the total target of £7m.

Therefore it stands to reason that to get to the £9m next year i could simply increase each individuals target by the flat 28.57%.

However, each individual didnt have an equal share of the £7m last year, as different members of the team have differing skill sets and levels of experience.

Also, last year each individual member performed differently against their own target meaning potentially some peoples targets were too easy, some were too hard. Therefore increasing each respective target with a flat 28.57% doesnt seem entirely fair.

Ive been using excel to crunch figures, using the 28.57% increase as a starting point for each person, and then trying to reduce or increase this 28.57 % for each individual, based on factors which I can proportion a value to, whilst still ensuring the resulting total global increase remains at £2m. For example, for each person the following values can be expressed as a % or decimal figure.

Indviduals 2018 revenue as a % of 2018 total revenue - percentage share of revenue

Indviduals 2018 revenue as a % of their own 2018 target - percentage to target

individual back order value as a % of global 2019 target - this is how much they already sold in 2018 but will not invoice until 2019, therefore this figure will count towards their 2019 target

id like to be able to create an excel spreadsheet which uses math to set 2019 targets dynamically.

Now I appreciate this is a long post, and my first, so apologies if I’m missing something or this isnt the right forum for this type of problem, but maybe someone will find this interesting enough to warrant some suggestions.

Many thanks to anyone reading this far and for any suggestions you might be able to offer.

Kr

Rob ]]>

a) Calculate the original loan amount using the following details:

P | = | Loan Amount (Principal) | ? |

r | = | Annual Interest Rate | 6.3% |

n | = | No. of periods per year | 12 |

t | = | Loan Term (years) | 5 |

PMT | = | Monthy Loan Payment | $395.53 |

Working backwards in Excel, PV = $20,899.43 using -PV(0.053/12,60,395.53,0,1) then $20,899.43 - $20,419 = $480.43

It's as close as I can get with Excel

PMT = $395.53

Bank Rate = 5.3%

Loan Rate = 6.3%

Term = 60 months

Payments are in advance

Spread ($) = $484.00

P | = | Loan Amount (Principal) | ? |

r | = | Annual Interest Rate | 6.3% |

n | = | No. of periods per year | 12 |

t | = | Loan Term (years) | 5 |

PMT | = | Monthy Loan Payment | $367.24 |

FV | = | Balloon Payment | $2,000 |

Hope you guys can help. Thanks in advance ]]>

**A bank offers a choice of two fixed term deposits.

Option A: Earning simple interest at 6.5 % p.a. for 4 years.

Option B: Earning simple interest at 8% p.a. for 3.5 years

David invests the same amount of money in both option A and B. Option B earns $105 more than option A.

Determine David's original investment.**

I=Prt

I=(P)(0.065)(4) & I=(P)(0.08)(3.5)

Therefor;

((P)(0.08)(3.5))-((P)(0.065)(4)) = 105

But then I get stuck because I can't figure out how to find the simple interest without knowing P.

I know the formula for principal is

P= I/(rt)

But I cant find that without knowing the simple interest. I feel like the answer is right in front of me but yeah I'm very confused.The answer is meant to equal $5250 in the book but no matter what I do I can't seem to get it to equal that. ]]>

Maybe my formula is wrong. Maybe it is an expected result of a linear function times an exponential decay.

Here's what I'm working with:

Single unit price is $11, discounts to a floor of $1.00 when you hit about 50,000 units

Can I get a formula with variables for the single unit price, floor price and the 50,000 quantity to which the floor is pinned?

Unit price = Decay function(single unit price), Total Price = Unit Price * Unit Quantity

We want Total Price to be a smoothly increasing value with no dips.

Hopefully, I've attached an image showing my formula issues.

Thanks,

Sam ]]>

The invoice total is net 114 plus 4.83 vat but our account system calculates 20% i cannot get it to 4.83. Please help ]]>

- Using the regression equation, predict the 5-year return of a fund whose 3-year return was 8%.

]]>

I have a problem I can't solve this exercise,

So I looked at the solution and I can not understand how they solved it...

Think I'm missing some basic math rules or something :

Capture d’écran 2018-11-22 à 20.39.42.jpg