Excel problem

PV Commerce Server

PV Commerce Server is an end-to-end solution enabling enterprises to rapidly deploy scalable and adaptable e-commerce applications that distinguish themselves from competition.

OVERVIEW
Rigorous business environment demands commerce applications that help enterprises to introduce products and services to market quickly, foster relationships with customers and suppliers, and clearly distinguish your
e-business from competition. Leveraging the PV Customer Relationship Server, PV Commerce Server can interact instantaneously to meet individual customer demands and take advantage of new market opportunities.
PV Commerce Server is a member of the PV net.enterprise Infrastructure - an open, end-to-end infrastructure of interoperable software modules for enterprise applications.





BENEFITS
>> Accelerate time-to-market by simplifying the setup and customization process of e-commerce applications with pre-built functions.
>> Automate online selling with functions that conduct online promotions, up-sells, and cross-sells.
>> Improve customer experience with more convenient and personalized buying processes.
>> Enhance business control with easy-to-use administration environment that allow business managers to manage catalogs and business flows without programming.
>> Protect your investment with solution based on open architecture which ensures continual support and seam less integration with other applications.


PRODUCT FEATURES
Catalog Management
Business managers can easily manage catalogs or malls through web interfaces with user authentication.


Personalized Shopping Experience
Customers can add purchase wish list, save items for next visit, place quick order as last purchase, simplify ordering process after initial registration or purchase.


Product Recommendations
Recommend products and services for cross-selling, up-selling, or substitutes of shortage products. Associate products attributes to increases the depth, breadth, and interrelatedness of recommendations.


Tier-based Pricing
Support tier-based pricing schemes for different customer classes, districts, tax structures, volume, and payment terms.


Collaboration
Business partners are able to contribute transaction, fulfillment, and related services through online workflow, information sharing, and validation.


Mobile Commerce
Users are able to browse catalog, request quotation, place order, check order status through mobile devices like WAP phone, PDA, and PALM, etc.


Dynamic Pricing
Various price negotiation models include auction, reverse auction,
sealed-bid auction, exchange. Buyers and sellers determine prices on a per-transaction basis.


COMMERCE SERVER OPTIONS
Portalvision provides four different editions and optional WAP support to
serve your special business needs.





Please contact our solution specialists for more details of PV Commerce Server and PV net.enterprise Infrastructure.

Actually, these three functions are designed for calculation of time value of money. To begin with, let me just briefly talk about what time value of money is.

Time value of money:
The central idea of time value of money is that a dollar today is more worth than a dollar tomorrow. For example, when you deposit a dollar in the bank and the interest rate is 5% per year, you will get 1.05 dollar next year. In other words, when interest rate is 5%, one dollar today is equivalent to 1.05 dollar after a year and 1 dollar in next year is only worth 1/1.05 dollar today. Technically, we will use PV(present value) as the value of money today and FV(Future value) as the value of money at a particular time in future. PMT is a bit more complicated. It is a regular cashflows (sorry for the jargon) within the period. For example, when you buy your house using mortgage, you may pay $10000 for the mortgage every month. This $10000 is PMT.

How to use the function
You have two ways to use these three function. Firstly, you can click insert --> Function --> select Financial --> select either PV, FV or PMT. This is the easier but slower way. Then, Excel will ask you to enter some data. (Rate: the interest rate, Nper: the time period, PV: The present value, FV: The future value, PMT: periodic cashflow within the period, Type: Whether the PMT is done at the beginning of the period or at the end of the period, type 0 is at the end and type 1 is at the beginning, in most situation, we will assume that the PMT is done at the end of the period). For cash inflow (i.e. When you receive cash), use +ve. For cash outflow (i.e.When you make payment), use -ve. For example, if you pay 10 per year, use -10 for PMT.
The second method is to use the syntax. What you have to do is to click on any cell on the spreadsheet and type in the function you want to use. For PV, you just have to type =PV(, then the excel will show you how you should enter the data. If there is some data you don't have, just skip that data (Of course, you have to enter a minimum set of data to let the function work). After you enter the data, just close the bracket with ). Then you will get the answer. You just have to do the same thing for FV and PMT.